Forum Discussion
Solved
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 mont...
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
Hi 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