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 chart
- Value 2 of the bar chart
But, I want the bar charts to sort by the Value 1 % (which is Value 1 / [Value 1 + Value 2]) or the Value 2 %. Thus, in the screenshot below, it would look like a waterfall with the blue colors sorting largest to smallest.
Is there a workaround for this? Or something I'm not thinking of?
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?
23 Replies
I think this would work:
Add a calculated column that contains the percentage value that you'd like to sort by. Call it "Sort_Pct" or something. Refresh the report and then go back to that sort menu in the top right of the column chart. The new Sort_Pct column should be an option there.
(Sorry for lack of detail I haven't had time to test this and this is just from memory.)
Add a calculated column with your % formula, go to the data model, select Value1 column, use the "Sort By" to change the sort column to your calculated column. Then, your Value1 should sort by your new column
Ah, missed the part about it being a measure.
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'
