Grouping Month-Year Distinct by Year

[Animanga008]

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.

[v-caitlyn-mstf · Accepted solution]

Hi@Animanga008，

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.

[amitchandak]

@Animanga008 ,

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

[Animanga008]

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.