Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Sort 100% Stacked Column Chart by Values Within Bar

Hi, I am trying to sort each column of a stacked bar chart with the largest percentage on the bottom and the smaller ones on top. Here is the graph right now:

So for the first column, I want the light blue section on the botton, and for the last one, I want the darker blue on the bottom, and the same for all the other ones. How do you do this?

 

I am sorry if this has already been posted I looked for a while and could not find it. Thanks!

General Comment

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous,

    Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      It is just a generic stacked bar chart, you should be able to recreate it with any data. I just want to reorganize the bars within the columns.