The graph's weekly values are not sorted in chronological order

[amanpatel9]

Hello, community,

I have been recently trying to sort the week's values into chronological order, which is correctly done in the source Excel file, but I can't update the same source order into the 'Line & Stacked Column chart'.

Please find the attached 3 images; (PowerBI - Graph) is the one which is not sorted chronologically and the (Power BI - Transform) and (Excel File) are the sources which can be seen visibily sorted in the order. 

Please let me know how this can be resolved,

Regards

[danextian]

Hi @amanpatel9 

Those week numbers are texts so they will be, of course, sorted alphabetically. You will need to create a custom column sort for them.  Start with a the year and then followed by the week number in "00" format. Example: 202401, 202410, 202425, 202501... Then custom sort your week number by that additional column. https://www.youtube.com/watch?v=4xapOrfLvbg 

[amanpatel9 · Accepted solution]

Hi, Thanks for supporting answer, I didn't tried this further as I found the solution with the other way. But thank you for quickly replying me with the solution.

[audreygerred]

Hi! By default the chart is sorting by value. Select your visual, click the 3 dots that appear in the upper right (or lower right depending on where your visual is on your page), click sort axis and change it from sorting on your measure to sorting on your dimension.

[amanpatel9]

Hi!  

I tried the option with three dots but I can't see the options you're referring to, I have tried many options like ascending to descending and also week number (attached image)  but it's not what I am looking into. 

Thanks