Forum Discussion
Anonymous
6 years agoNot applicable
Rank stacked column chart
Hi, Currently , I have stacked column chart below. The order of legend is defaultly as A-Z. How to rank the legends based on the YTD for every legend? Thanks for any help 🙂...
- 6 years agoYou could use RANKX to create a calculated column that ranks each category. You just have to make sure that each category only has 1 rank, so every year for that category and every month it must be the same number ranking.
Then you can use Sort By Columns to sort the category by rank and the legend will automatically update.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column
You may also be interested in Ribbon chart, which shows relative rank for each category and how it has changed from month to month: https://docs.microsoft.com/en-us/power-bi/visuals/desktop-ribbon-charts
amitchandak
6 years agoSuper User
Anonymous , I doubt you can do that for legends. Please check and vote for an idea.