Forum Discussion

schoden's avatar
schoden
Icon for Post Partisan rankPost Partisan
5 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
    5 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
Icon for Community Champion rankCommunity Champion
5 years ago

schoden figured out how to do it. There is very limited stuff out and about but anyway, hopefully the below screenshot is kind of what you were wanting?

 

You will need to create the following measures and two tables:

S_Table2_Cat uses Summarised. 

S_Table3_Status is just "Enter Data" and column title "Status" with Top, Middle, Bottom as data.

Relationships in Model view as follows:

Hope it's what you're after mate! Was interesting to say the least lol!