Reo-ordering my x-axis points

[Anonymous]

Hi,

I jsut added in the June weeks to this graph but I can't figure out to switch how they are appearing on the x-axis. It is out of date order! Many thanks for your advice!!

[tarunsingla]

Your x-axis field is not of Date type; hence the points are not sorted as desire. Those are sorted alphabetically.

You may either name your weeks in such a way that those would align with calendar dates (e.g. prefix with 0 where needed, etc). Or use another more powerful feature Power BI has called Sort By Column.

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column#sort-using-the-sort-by-column-butto...

[Anonymous]

Thank you for the date tip!! Adding in 0's fixed it immediately!

Another question - How can I limit the number of weeks appearing on m y x-axis. I would like it to show 6 weeks at a time.

many thanks for all your help!

[tarunsingla · Accepted solution]

Great, add a visual level filter. Drag the actual date field to the visual level filters, apply relative date filtering set to last 6 weeks.

[Anonymous]

Thank you!!