Reverse the text order on x-axis in line chart

[bv_saisuraj]

I am unable to reverse the text order on x-axis in line chart. below image

[v-weiyan1-msft · Accepted solution]

Hi @bv_saisuraj ,

I am not sure how your semantic model looks like, based on your description, I created some dummy data.

As @TomMartens replied, you can create an index column in the Power Query Editor.

Select the Month column in the Data panel on the right, do the following.

Then select your visual object and click on the ellipsis in the upper right corner to change the sorting method to ascending order.

Result is as below.

You can check if the last step above is included in your operation.

Hope that helps.

Best Regards,
Yulia Yan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TomMartens]

Hey @bv_saisuraj ,

you have to be aware that by default axis labels are sorted alphabetically, this makes M4 larger than M11. I assume you have to create an extra column in the table that holds the M1 ... MXX column and use this new column to sort the M1 ... MXX column. Í recommend this article: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-deskto...

Hopefully, this helps to tackle your challenge.

Regards,

Tom

[bv_saisuraj]

Hello Tom 

Thanks for your response. I tried the way mentioned in the article. keeping an index column 0,1,2,3... corresponing to M1, M2, M3, M4..... respectively and tried sort in the column tools but there is no change in the order.

Regards

Suraj

[qqqqqwwwweeerrr]

Hi @bv_saisuraj 

you can follow this video there exactly same problem is mention: https://youtu.be/PUaFtLpIMvY?si=vYaQF5RzvP_VtyUK

Regards

[bv_saisuraj]

Hello @qqqqqwwwweeerrr 

Thanks for your response. I tried the way mentioned in the video. keeping an index column 0,1,2,3... corresponing to M1, M2, M3, M4..... respectively and tried sort in the column tools but there is no change in the order.

Regards

Suraj