Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
Typically, I just use yyyy-mm format to sort.
Ex: 2018-08
From [Date] column...
Year-MM = YEAR([Date]) & "-" & FORMAT([Date], "MM")
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |