Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Sorting by Legend and Measure at the same time

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). Se...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    1 year ago

    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's avatar
Ritaf1983
Super User
1 year ago

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#M1168132

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly