Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
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?
Solved! Go to Solution.
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?
Cool. I'm looking forward to hearing more.
Ah, missed the part about it being a measure.
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.)
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |