cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
no066883 Frequent Visitor
Frequent Visitor

Reo-ordering my x-axis points

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!!

 

re-order.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
tarunsingla Member
Member

Re: Reo-ordering my x-axis points

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.

Untitled (1).png

4 REPLIES 4
tarunsingla Member
Member

Re: Reo-ordering my x-axis points

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...

no066883 Frequent Visitor
Frequent Visitor

Re: Reo-ordering my x-axis points

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 Member
Member

Re: Reo-ordering my x-axis points

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.

Untitled (1).png

no066883 Frequent Visitor
Frequent Visitor

Re: Reo-ordering my x-axis points

Thank you!!