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,
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
Hi 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?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.
