Display month and year in Descending order in line and stacked column chart

[Anonymous]

I have line and stacked column chart in x-axis i have month/year like 11/2021,12/2021,12/2020 i need to display in descending order.How can i achieve it?

[v-zhangti · Accepted solution]

Hi, @Anonymous 

Tested stacked column charts can be selected directly on the view in descending order.

Add calculation column:

Rank = RANKX('Table',[date],,DESC,Dense)

Adding Rank to the X-axis of the line chart table allows you to sort in ascending and descending order.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous ,

from nov-21 onward we have option sort legend in the visual in three dots.

else create a new columns

month/year 1 = [Month year]

Month year sort = year([Date])*100 + month([Date])

sort Month/year1 on month year sort and use month/year 1 in the visual

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c