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

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....

Sean's avatar
Sean
Community Champion
10 years ago

Can you provide a sample of what your data looks like? How its organized?

 

You CAN actually sort the 100% stacked column chart sort by Measres!

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Cool. I'm looking forward to hearing more.

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    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:

    • Axis = Developer
    • Value
      • Non-Story Duration In Minutes
      • Story Duration In Minutes
    • Sean's avatar
      Sean
      Community Champion
      10 years ago

      Anonymous

      Create these 2 Measures

       

      Story Durations = SUM('Dev Time Tracking'[Story Duration in Minutes])
Non-Story Durations = SUM('Dev Time Tracking'[Non-Story Duration in Minutes])

      then create your chart as in the picture => placing these 2 Measures in the Values area

       

      then sort... Let me know if it works!

      • Sean's avatar
        Sean
        Community Champion
        10 years ago

        This works with the Columns too by the way...