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?

     

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

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

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

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      10 years ago

      Ah, missed the part about it being a measure.

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