Forum Discussion
Help Needed in Nested Sorting for Hierarchical Bar Chart
Hi Everyone,
I'm a begginer in Power BI, We are working on a Tableau to Power BI Migration project where I'm facing some difficulties in converting one bar chart to power bi.
Scenario : I have a category and subcategory and sales value plotted in a bar chart, I have turned of Concatenation, I want to show it by Category group (Highest Category First) then inside each group show sucategory bars (Highest Subcategory First).
I was able to achieve the first sort by creating a Total colum using ALLEXCEPT(). but I'm not able to do the second layer sorting.
Any help is appreciated.
Screenshot below:
Expected : I want to show highest subcategory in DESC in each category.
Sample File Download Link : Sample PBIX File
Regards,
Rinto
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
15 Replies
rintoalappat , When you sort ox Axis Category / subCategory, As of now you do not have option to sort subCategory based on value
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
Thank you for the alternate solution. I do have some stacked legeds as well on the bar, I believe its not possible with Matrix bar visual
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
rintoalappat great minds are already here and provided the appropriate solutions, just curious, is this what you are looking for:
yes, subcategory is showing properly. but office supplies category should come at the beginning as per value desc.
is this whate you looking for
yes, This is what I'm looking for. Could you please share the steps which you followed. Thanks in Advance.
