Forum Discussion
rmcgrath
Advocate III
Advocate IIIX-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 dependin...
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
PijushRoy
Community Champion
Community ChampionHi 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
rmcgrathAdvocate III
Advocate IIIOh yes!! I forgot about that...thank you...it is text! I will change it.