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 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.
Hi sorry for the trouble. That original file was connected to a semantic model in our service. Try this one instead, which has everything stored within the PBIX.
https://drive.google.com/file/d/1Ec3sOa8j99gclREc0n2kOxaWTySFR6HX/view?usp=sharing
