Need Help: Sorting Columns in Descending Order in Power BI

[Anonymous]

Hi Power BI community,

I hope this message finds you well. I am currently working on a project in Power BI and I'm facing a challenge with sorting columns in descending order. Specifically, I want to convert certain columns to display in descending order on my stacked column chart.

Could anyone please guide me on how to achieve this in Power BI Desktop? I have attempted to explore the "Sort ascending" and "Sort descending" options in the Visualizations pane, but I am unsure if this is the correct approach.

Your assistance and insights would be greatly appreciated!

Thank you.

[Anonymous]

Hi @Anonymous ,

Is that what you want?

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

When I use descending order to sort, it comes out like this.

[Anonymous · Accepted solution]

Hi @Anonymous ,

According to your screenshot, you have this in descending order by the first letter of the characters on the x-axis:

Please note that the screenshot I provided has a choice of what to sort by on this side, so please select it as your VALUE and not the x-axis text:

If you don't have this option in your bar chart, please describe how you created this visual object, thank you!

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[marcelsmaglhaes]

Hi @Anonymous 

Take a look in this link: Change how a chart is sorted in a report - Power BI | Microsoft Learn