Forum Discussion
Truble with column chart sorting
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