Forum Discussion
Sort 100% Stacked Column Chart by Percentage Values
In my Power BI Desktop file, I'm using the 100% Stacked Column Chart to compare 2 values for 10 people and the only options to sort the bars are: x-axis value (person's name) Value 1 of the bar ch...
Okay I got the %s you say in the Post above - and they calculate exactly as you say!
However we were there before with the calculated columns only - those were producing the same results?
And you said they were wrong?
A workaround (ugly) is to set the aggregation to 'Average' instead of 'sum' or 'count'.
You can then sort on 'Average of value1' or 'Average of value2'