Help Needed in Nested Sorting for Hierarchical Bar Chart

Hi rintoalappat 

Unfortunately, this functionality is unavailable.

Please refer to the linked discussion:

https://community.fabric.microsoft.com/t5/Desktop/Sorting-by-multiple-columns-in-clustered-column-chart/m-p/728818

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