Forum Discussion
Graf Y axis data sorting
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
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
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.
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
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 regardsM.