Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am having trouble reproducing this solution: https://community.powerbi.com/t5/Desktop/How-to-group-months-by-year-on-a-line-chart-visual-Axis/td-...
How do I display data over many years continuously, grouped by the months only, distinguished by the year; without using a legend or by using a calculated column that gives the dates column a quant value (like YEAR*100+Month*10=value and then sort by)? Or alternatively, I'm not looking to create a key table that separately gives a value to the summarized view of my data's dates.
I am just trying to reproduce these solutions but it's still grouping all the months together by name, not distinguishing between year.
Screenshot is my test example. I just used the calendar function to create values between two years and then randomly generated values.
Solved! Go to Solution.
Hi@Anonymous,
After switching off concatenate labels as:
then drill down like:
Here is the output:
If you want to learn more, please refer: How-to-change-the-granularity-of-date-in-X-axis
Best Regards,
Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi@Anonymous,
After switching off concatenate labels as:
then drill down like:
Here is the output:
If you want to learn more, please refer: How-to-change-the-granularity-of-date-in-X-axis
Best Regards,
Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous ,
Either you have these columns and use those
Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")
And use on x-axis
or
Month= FORMAT([Date],"mmm")
Month sort = month([Date])
Then have Year and Month on x-axis, sort on them. Uncheck concatenated labels. and try
refer the power bi part of this video - https://www.youtube.com/watch?v=2P5BBRN853c
So the first proposed solution I know works for sure, because you're effectively giving the different years and months a quant value.
Your second proposal addresses what I'm asking.
My questions are:
1) Any idea why I can't get my year buckets to appear (2020, and 2021)?
2) What do you do with creating a Month name field (Month= FORMAT([Date],"mmm")) and then a Month digit field (
Month sort = month([Date]))? I don't understand how those two values are used to sort across various years.
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |