Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

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...
Tips and Tricks
  • Sean's avatar
    Sean
    10 years ago

    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?

     

     

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Sean once again, thank you so much for dedicating so much time to this.  I've been very busy today and haven't been able to get back to it yet.

 

But, in a quick glance at what you've done, it looks like something is off.  

 

For each Developer, Story Durations + Non-Story Durations = Total Durations [for that Developer, not for everyone]

 

The formulas you have look like they're calculating the Story % on a basis of all Developers.

Thus in the example above...

Ben should have Story % of 480 / 480 = 100% and Non-Story % of 0%
Tim should have Story % of 120 / (120 + 210) = 36.4% and a Non-Story % of 63.6%

 

Make sense?

Sean's avatar
Sean
Community Champion
10 years ago

DELETED.