Forum Discussion
Help Needed in Nested Sorting for Hierarchical Bar Chart
Hi rintoalappat
Unfortunately, this functionality is unavailable.
Please refer to the linked discussion:
And vote for the linked idea:
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=facafdf4-1c63-4db8-a385-c120e4607c45
To rank the values hierarchically you can use a matrix with conditional formatting.
It is also a much more efficient graph for ranking scenarios than a clustered column:
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi rintoalappat
No, and don't recommend using stacked bars.
Please refer to my linked blog post which explains why."Home experiments" and stacked bar graphs (madeiradata.com)
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Thank you. Its working for me. I do have one more query in the same DAX, on the same bar chart, I have visual level measure filter which restricts the data for sales >=1.
The abpve dax is working without the filter, but if I add that visual level filters, the sort s not working properly. I know we have to add that filter somewhere inside the m2 calculation summarization part.
Could you please help me with that as well ? Appreciate your help and time.
I don’t understand, please share the file with the problem
Scenario : Need to show subcategories which having Sales more than 50.
Problem : When I apply visual level filter, its resetting the sort.
PBI file : Sample PBI File - Filter Interfere with Sort