Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi all, I've searched high & low and unable to find a solution to this.
What I am trying to do is take the chart below, and sort it by the "Health" legend first (this is what the chart shows). Secondly I want it to sort high-to-low within each item in the legend.
As you can see, all of the blue bars are not sorted properly, but the legend is sorted in the correct order.
Solved! Go to Solution.
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,
Share the download link of the PBI file.
Hi @cbschley
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 @cbschley
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.
How to Get Your Question Answered Quickly
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 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,
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.
Hi @cbschley
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...
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
121 | |
112 | |
58 | |
57 |