Forum Discussion
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...
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 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.