topic Re: Graf Y axis data sorting in Custom Visuals Development Discussion

Graf Y axis data sorting

Martin_Machovec — Wed, 16 Jul 2025 09:03:20 GMT

Got this graf but I want to switch the order of years on y axis from oldest beeing on the top to the lates on the bottom, so far i tried variaty of different aproches including adding new culumn and table with sorting indexes, unfortunetly, none of these worked. Very simple stuff in excell in Power Bi total nightmare. Consulted with Copilot and chat GPT, tried variety of different aproches with no luck. Is it even possible? Thank you for any advice

Re: Graf Y axis data sorting

lbendlin — Wed, 16 Jul 2025 12:18:51 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Graf Y axis data sorting

Martin_Machovec — Wed, 16 Jul 2025 12:27:26 GMT

This is required solution:

How ever somethink that is done with excel in a second takes unfortunetlly very long in Power BI and you need to use python for that, because of all the limitations that are provided with Power Bi. So not a issue for me anymore and this matter can be closed. But to MS developers if you are reeding this, come on... wake up this stuff is not so hard to implement.

Re: Graf Y axis data sorting

dm-p — Wed, 16 Jul 2025 23:12:20 GMT

It can already be done in the core product. If you're using a numeric field, ensure that your axis field is set to Categorical rather than Continuous (which is the default for numeric columns), e.g.:

This will ensure that the visual has a discrete entry on the scale for each unique value. Then, you can sort your field as usual, e.g.:

The chart is now sorted in ascending order of year as required, e.g.:

Regards,

Daniel

Re: Graf Y axis data sorting

Martin_Machovec — Thu, 17 Jul 2025 10:21:22 GMT

Dear Dm-P,

thank you for your reply, I tried to replicate your solution and it works as well. Thank you for your advice and time invested to reply to my problem and teaching me new stuff.
Best regards