Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
Hi @Manasa1994 ,
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.
Hi @Manasa1994 ,
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.
When I use descending order to sort, it comes out like this.
Hi @Manasa1994 ,
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.
Hi @Manasa1994
Take a look in this link: Change how a chart is sorted in a report - Power BI | Microsoft Learn
Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
82 | |
62 | |
61 | |
58 |
User | Count |
---|---|
160 | |
114 | |
100 | |
74 | |
65 |