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 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_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
