Forum Discussion

Deemo's avatar
Deemo
Advocate II
6 years ago

Cannot sort stacked bar chart as per values

Want to sort stacked chart's bar as per values instead of legend

6 Replies

  • Deemo you should look at ribbon chart and tweak setting in the Format pane to get the expected result

     

     

    I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.

     

     

    • Deemo's avatar
      Deemo
      Advocate II

      Thanks parry. Already tried it. User wants largest one at bottom and also total of each bar on top.

       

      • parry2k's avatar
        parry2k
        Super User

        Deemo interesting, one hack could be to create a calculated table with sort of values by negative and that will make the largest number to show at the bottom, I don't see anything out of the box expect some workaround.

         

        I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

        Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.

         

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Deemo ,

    Because it contains multiple categories, sorting by column values has no effect.

    Best Regards

    Rena