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

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.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Have you gotten it to work with a calculated column rather than a measure?

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