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.
here's a link with the PBIX file and the visual in question:
https://drive.google.com/file/d/1gKdnAhlLS8zFkHlcpLVztys8j0TG8aMv/view?usp=drive_link
Ideal 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=sharingHi Anonymous
Please refer to the linked discussion, the sorting inside the hierarchy in graphs is a known issue.
Ahmedx solved it with the dax measures and I suggested other alternative with matrix + bars
https://community.fabric.microsoft.com/t5/Desktop/Help-Needed-in-Nested-Sorting-for-Hierarchical-Bar-Chart/m-p/3542925#M1168132If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi,
I converted the visual to a Table and sorted the Health and Value fields in ascending and descending order respectively (by holding the Shift key). I then created a clustered column chart.
Ashish_Mathur this is exactly what I was looking for!
When I try it on my end though, after I do the sorting step within the table format, I change it back to a clustered-column chart and it does not retain the sorting. Would you know how I can force it to retain the sorting order?
Would you be able to upload your PBIX file that you modified?
