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?
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
Proud to be a Datanaut!
I'm inexperienced when it comes to DAX / Measures / Calculated Columns, but is it possible to write a Calculated Column to do what I need? I thought it had to be a Measure since it's aggregating across multiple records? Thanks for following up....
Nice! Thanks Sean.
My data is like this:
Each Developer records their time by Category. I created the following 2 Calculations:
Story Duration in Minutes = IF('Dev Time Tracking'[Category] = "Story", IF('Dev Time Tracking'[Start] >= 'Dev Time Tracking'[End], 0, DATEDIFF('Dev Time Tracking'[Start], 'Dev Time Tracking'[End], MINUTE)), 0) Non-Story Duration in Minutes = IF('Dev Time Tracking'[Category] = "Story", 0, IF('Dev Time Tracking'[Start] >= 'Dev Time Tracking'[End], 0, DATEDIFF('Dev Time Tracking'[Start], 'Dev Time Tracking'[End], MINUTE)))
Is there a better way to write those Calculations?
Either way, my 100% Stacked Column Chart has: