Forum Discussion
Sort 100% Stacked Column Chart by Percentage Values
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?
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!
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
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!
This works with the Columns too by the way...
Sean Thanks so much for doing all this work here.
Unfortunately I did exactly what you suggested, but it's not working. The Measures you gave result in a whole number, not a percentage, so it still sorts by that whole number. So if someone has much larger numbers, they will appear first, regardless of their percentage.
Anonymous Wait a second now...
Turn on the Data Labels and tell me What do you see... Don't you see %
More impotantly what's in the PAGE LEVEL Filter?