Forum Discussion
Sort by column after grouping
Hi All, I have a measure which calculates the percentage of missing data in a column. I have added this measure to the bar chart below. X-Axis - Attribute Y_Axis - Measure Legend - Region...
Hi obriaincian
Sorting the legends by the value within a specific category currently isn't supported. There are workarounds but they aren't perefect. In the screenshot below, Geo column is ranked by Total Revenue. The ranks are then materialized using a disconnected table and then a column from that disconnected table is used in the visual.
The second chart uses small multiples.
Please see the attached sample pbix.