Forum Discussion
Truble with column chart sorting
Hi to all power BI users!!
I'm in truble with an apparently semply issue. My scenario is like the same:
Suppose you have a table like this:
Comp1 Comp2 Comp3 Comp4
| Milan | 14,2 | 13,17 | 13,19 | 13,17 |
| Rome | 14,8 | 13,11 | 13,12 | 13,1 |
each column is an average value
I try to generate an histogram like this:
My intention is to sort data by the average value. But when I select the descending order by average the sorting remain costantly the same by the legend alfabetically sort.
Has anyone suggestion for resoleve my issue??
Tanks in advance
Ago
4 Replies
Hi AgoZ_KH ,
This cannot be done directly using this visual, when you sort by value it'll sort by the total value of each cluster and not the individual bars.
These people had a similar issue and was suggested to create a Rank Column and then sorting by Rank
https://community.powerbi.com/t5/Desktop/Clustered-Bar-Chart-Sorting/m-p/729143
https://community.powerbi.com/t5/Desktop/Sorting-legend-by-value-in-clustered-bar-chart/td-p/538619
Hope this helps
Ranking will only give you control on the order of the legend, but it will still not change the order within each city.
Basically the design of the charts are such that the legend remains in the same order for each category of the axis, either automatically selected by alphabetical order which is happening in your case, or when you create dummy measures for each category and then place them in a desired order.
In both case it will maintain the order.
You may like to submit the idea or vote existing ones here https://ideas.powerbi.com/forums/265200-power-bi-ideas?query=sort%20legend
Thanks for the very quickly answers Tara_ & abhie.
I understand the design of sorting by legend in a clustered chart -an fundamentaly I agree whith this.
Thinking of resolve my matter using a different view for the chart; i.e. using drill-down expanded hierachy. Not so clear as the first chart choiche but good as work around ...
Ago
