Forum Discussion
Dynamically sort (Top 10 Values Vs Other) in Stacked Column Chart
Dear Team, I plotted stacked column chart for Top 10 InventoryDollars Vs Vendor ( Other than top 10 considered as Others). X axis - Day/month, Y axis- Inventory dollarys value. But the issue is - Bar values are sorted by vendor name by default in alphabetical order (Refer the attached image). Is there anyway sorting the stacked column bar by values? ie Way to put the the the larger number at the end and grow the stacked till the lowest?
Thanks in advace.
Best Regards,
Chinma.
Hi chinma
Unfortunately, this functionality is not available, as it means that every column in potential can be sorted in an individual order.If your goal is to show the dominance of every vendor vs. all by dates, highly recommend using small multiples instead of this stacked graph.
You can download pbix with the example that I prepared for one of my lections from the attached link (sheet : alternatives) :
The article about problems with stacked bars :
https://www.madeiradata.com/post/home-experiments-and-stacked-bar-graphs
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
1 Reply
- Ritaf1983
Super User
Hi chinma
Unfortunately, this functionality is not available, as it means that every column in potential can be sorted in an individual order.If your goal is to show the dominance of every vendor vs. all by dates, highly recommend using small multiples instead of this stacked graph.
You can download pbix with the example that I prepared for one of my lections from the attached link (sheet : alternatives) :
The article about problems with stacked bars :
https://www.madeiradata.com/post/home-experiments-and-stacked-bar-graphs
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.