Forum Discussion
X-axis not sorting correctly
I have a line chart:
As you can see the X-axis does not sort correctly. I would like the weeks to go in order but it seems pretty random. How do I ensure it goes from 1-52 (or 53 depending on the year)?
Hi rmcgrath
Please check the datatype of the Week column, is it Text or Integer/Whole number? Please make sure the datatype should be a whole number or Integer.
Step 2 -
Change the visual sort order
Step-by-step info https://learn.microsoft.com/en-us/power-bi/consumer/end-user-change-sort
3 Replies
Hi rmcgrath
Please check the datatype of the Week column, is it Text or Integer/Whole number? Please make sure the datatype should be a whole number or Integer.
Step 2 -
Change the visual sort order
Step-by-step info https://learn.microsoft.com/en-us/power-bi/consumer/end-user-change-sortOh yes!! I forgot about that...thank you...it is text! I will change it.
i have same problem, but i can solve with this trick
