Forum Discussion

schoden's avatar
schoden
Post Partisan
4 years ago
Solved

Sort Legend Dynamically By its Value

Hi Community,    Is it possible to sort the legend dynamically by the value in its column( highest to lowest)   There is hardcoded way which is not I am after or alphabetically sorting.   Sort e...
Need Help
Show and Tell
  • TheoC's avatar
    TheoC
    4 years ago

    schoden did you check out the solution I put forward? I attached the PBIX in an earlier reply. I believe it is what you were after. Hope it helps!

TheoC's avatar
TheoC
Community Champion
4 years ago

schoden if you want to use dax to achieve the above, you can create a summarised table, add a Calculated Column using SWITCH to change the color name to a digit, and link the summarised Color field to original table. Then create a Calculated Column using "Related" in the original table to bring back the digits.

  1. Color Table = SUMMARIZE ( Table1 , [Color]) 
  2. Color Rank = SWITCH ( [Color] , "Black" , 1 , "Blue" , 2 , "Red" , 3 , 0 )
  3. Relationship Color Table [Color] to Table1 [Color] (one is to many)
  4. In Table1 create Calculated Coloumn
    1. rColor = RELATED ( Color Table[Color] )

Done 🙂

schoden's avatar
schoden
Post Partisan
4 years ago

Hi TheoC  This will always put Black color as 1, Blue as  2, Red as 3 as its hardcoded, 

I want dynamically sorting based on values  alloted to the colors. 

 

Feb  ( Black= 7, Blue=6, Red= 5 )  which is stacked as Black, Blue , Red .

March ( Blue= 8, Red=8, Black= 1) which is stacked as Blue , Red , Black.