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?
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
That was what I initially tried to do (I should have mentioned that), but I found out the Sort By value doesn't allow you to select Measures.
Ah, missed the part about it being a measure.
Have you gotten it to work with a calculated column rather than a measure?
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....
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!