0

I created a stacked column chart in Power BI. It displays data from FB in my scenario. My x-axis displays the month and year and the y-axis displays the total number of posts on that month. It displays only 20 months whereas my data has more than 20 months. Is there a limit or how do I display all months here!!

enter image description here

Mboolean
  • 394
  • 3
  • 14
user388969
  • 337
  • 1
  • 9
  • 30
  • No limit to show already imported data from FB as we can see YearAndMonth showing on filter. Could you share the data to take a look? (mainly M code) – Mboolean Jun 04 '19 at 15:23
  • I am a newbie in powerBI, are you asking for the query what is M code? – user388969 Jun 04 '19 at 15:36
  • Yes, Your query. FYI.. Power query language also called M language. – Mboolean Jun 04 '19 at 16:08
  • let Source = Facebook.Graph("graph.facebook.com/v2.8/Me/posts"), #"Removed Other Columns" = Table.SelectColumns(Source,{"message", "created_time", "id", "story"}), ParseYearAndMonth = (someText as text) as text => DateTimeZone.ToText(DateTimeZone.From(someText), "yyyy MMMM"), invokedFunction = Table.AddColumn(#"Removed Other Columns", "yearAndMonth", each ParseYearAndMonth([created_time]), type text) in invokedFunction – user388969 Jun 04 '19 at 16:53

0 Answers0