how to reorder dates on X-axis of the charts

[kathyyy19]

Hi everyone,

I created a few charts in power bi (line chart, 100% stacked column chart, stacked column chart). The X-axis shows the date of each week (my week runs from every Thursday to Wednesday). 

Below is a screenshot of one of the X-axis. I see that 6/15 is before 6/8 and I tried to sort axis asceding by 'start of week' but it didn't work. Can someone let me know how to make them in the correct order please? I have a calendar table and one column being 'start of week'.

This is how the order of the date in my calendar table looks like:

Thank you!

[vicky_ · Accepted solution]

You need to change the type of your dates. Right now, they are being sorted as if they were strings. 
Power Query can do that for you - guide here

[PhilipTreacy · Accepted solution]

Hi @kathyyy19 

Are you actually plotting the date on the x axis?  Looks like you are not, if you are using a text field like the 'Start of Week' you created, you'll get this issue because the values on your x axis are actually text, not dates.

Try just using the date on the x-axis.

Regards

Phil

[kathyyy19]

Thank you Philip! I think I figured it out. Yes, you are right. My dates are in text format not dates so I transformed them into dates. Then I used format visual->x-axis->type, and changed type from 'continuous' to 'categorical' and the x-axis are now showing start of week dates. 

[vicky_ · Accepted solution]

You need to change the type of your dates. Right now, they are being sorted as if they were strings. 
Power Query can do that for you - guide here

[kathyyy19]

Thank you Vicky for your help!!