Sort Line Chart Values

[Syndicate_Admin]

Hi guys, I had been graphing without problems, normal line graph, the data is by weeks, example 49, 50, 51 etc, but now that I finish the 52 comes the 1, that value I want you to show on the right side of the 52 example
48 49 50 51 52 1

But it obviously shows it at the beginning, which is not what I'm looking for

1 48 49 50 51 52

Is there a way or trick to manually sort that data by week?

[Anonymous]

I think you are asking like this .

Make Sure If it is ok rply me.

[Syndicate_Admin]

That's how it is, just as you show it in the picture

[Anonymous]

It Simple dude only i used sorting nothing else done here 

refer the above screenshot..

[Fowmy]

@Syndicate_Admin 

Add an additional column in your date table combining year and week number for example  and use in on the X-Axis:

Year Week = 'Date'[Year]  & "-" & 'Date'[Day of Week Number]

[Syndicate_Admin]

Excellent thank you very much, I thought about it but I didn't apply it hahahaha