Sort on the basis of legend values and date hierarchy

[Anonymous]

Hi,

Consider a below Clustered column chart, On X-axis there is a date hierarchy (years, months and quarters) and on Y-axis there are counts of various categories from the same column of the table. We want to sort by descending on the basis of Y-axis category counts for each month separately.  

For example: for August month it should be sorted as 5,5,3,3,2,2,2,2,1 and display the bars accordingly.  It should be applicable to all the date ranges we took on X-axis at a same time.

Please let me know how to achieve this.

Thanks in advance.

[CoreyP]

I don't think this sort option is available as a default, but I believe a workaround from another post from a few days ago could be used. https://community.fabric.microsoft.com/t5/Desktop/Can-the-Column-Sequence-within-a-Matrix-visual-be-...