Forum Discussion
Visualizing data over time - more than 12 months
Hi there
I have sales data for more than 12 months back. I want to see all of the months (there are 15 months right now), next to each other (column chart). But BI Desktop is showing me only 12 months.
What should I do to see all months on one graph?
Sobek
Hi Sobek,
As the Chihiro said, you should use Year-Month column as X-axis level, please create the Year-Month calculated column using the formula.Year-Month = Active[Year]&"-"&Active[Month]
If this still can not resolve your issue, please post more details, sample table or screenshot for further analysis.
Best Regards,
Angelia
4 Replies
What data type/column are you using as axis?
If you are using date hiaerarchy's Month as axis. This will cause issue.
To have more control over time intelligence. I usually create custom date table with Year-Month column.
Using that column as axis, you can show all months with data.
Hi Sobek,
As the Chihiro said, you should use Year-Month column as X-axis level, please create the Year-Month calculated column using the formula.Year-Month = Active[Year]&"-"&Active[Month]
If this still can not resolve your issue, please post more details, sample table or screenshot for further analysis.
Best Regards,
AngeliaHi everybody, thanks for the solution above, it worked for me, BUT now I can't figure out how to make the x-axis display in the right order!?
I hope you can help out, thanks for being a great ressource.
/Niels
Typically, I just use yyyy-mm format to sort.
Ex: 2018-08
From [Date] column...
Year-MM = YEAR([Date]) & "-" & FORMAT([Date], "MM")
