Forum Discussion
Sorting by Legend and Measure at the same time
Hi,
PBI file here. I sorted the table first (as described above) and then created a copy of the table. I then converted the table into a clustered column chart. Apply conditional formatting on the chart.
Hope this helps.
Hi Anonymous
Please apply the following steps :
1. Switch on sort by values from layout:
2. You have 2 sorting options in the graph
a. sort axis :
b. sorting legend:
Result
The 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 Ritaf1983 , When I select "sort by values", it doesn't seem to do anything to the visual. I do see the multiple options of "sort by" in the options, but nothing seems to allow me to sort by "Health" first, then "Values" high-to-low.
Sorting selected:
Hi Anonymous
please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
here's a link with the PBIX file and the visual in question:
https://drive.google.com/file/d/1gKdnAhlLS8zFkHlcpLVztys8j0TG8aMv/view?usp=drive_linkIdeal state would be for it to sort the "Health" buckets from Excess -> healthy -> below ss -> out of stock. From there, each of those "health" categories should then be sorted high-to-low for the values within that bucket.
Hi,
Unable to open the file. See attached picture.
