I need to have this graph from week 50 to week 51, not the other way around as showing right now.

[josephsoto]

[josephsoto]

Hi,

Thanks for your efforts to help.

I was able to fix it by sorting the axis.

[Anonymous · Accepted solution]

Hello @josephsoto,

Looking at your x axis, since you have a value for "51B" the column you are using is not numeric and therefore Power BI is not sorting in numerical order. My recommendation is to create an additional table which has a column for the values in your x axis and then a column for the order you would like to impose. Example:

Value	Order
51B	2
50	0
51	1

Once you have this, you can create a relationship between this new data source and the data source containing your x axis. You'll need to add a new custom column to the orignal data source you can use the related function in DAX to bring the order over from the new data source. From here, it's simply a need to sort one column (the one containing your x axis values) by another (the order column you brought in from the new data source).

Both hyperlinks contain additional documention directly from Microsoft. I hope you find this helpful!