Sorting by Legend and Measure at the same time

[cbschley]

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.

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[Ritaf1983]

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

[cbschley]

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:

[Ritaf1983]

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  

[cbschley]

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. 

[Ashish_Mathur]

Hi,

Unable to open the file.  See attached picture.

[cbschley]

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 

[Ashish_Mathur]

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.

[cbschley]

@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?

[Ashish_Mathur · Accepted 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.

[Ritaf1983]

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