X-axis not sorted chronoligically

[Johann80]

Hi all

I just started using Power BI so I appologize for the basic question 🙂 I tried to create a chart showing the revenue by Month. 

For some reason, the X axis is not sorted chronologically as you can see February and January Months are inverted, reason being (I suppose) is that February Revenues were higher than January ones and the sorting was done by the Y-Axis.

I tried to change the sorting in Column Tools, I also tried to create a new data column with Date format change but it does not seem to work

I must be missing something 🙂

 

[grazitti_sapna]

Hi @Johann80 

1. Create a calculated column using the below formula:
   Month Num = MONTH(Date_Column)

2. In the Table view, select the column that contains the month names.
   Then, from the Column tools in the toolbar, use the Sort by Column option and choose the Month Num field.

This will ensure the month names are sorted correctly in your chart as well.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

[Johann80]

Hello

thanks very much for your answer, I have the below error message when trying to create this new column :

 "Failed to resolve name 'Date_Column'. It is not a valid table, variable, or function name.

[v-hjannapu]

Hi @Johann80,
Thank you for reaching out to the Microsoft fabric community forum.

I would also take a moment to thank @grazitti_sapna  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

To fix the month sorting issue, ensure your Month column is set as Text, and you have a separate MonthOrder column with values like Jan = 1, Feb = 2, etc. Then go to Column tools → select Month → Sort by Column → choose MonthOrder. Also, check the visual is sorted by Month, not by Revenue.
Please find the attached file and screenshot for your reference.

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it

Best Regards,
Harshitha.
Community Support Team

[Johann80]

Hello all

thanks for your answers ! For some reason the above solutions did not work, however I have been advised by a friend a tip which works so thought it could be useful to share it

I have created a Hierarchy for the Month data "Month Hierarchy" and it fixed the issue

[v-hjannapu · Accepted solution]

Hi @Johann80 ,

Just wanted to check if you had the opportunity to review the suggestion provided?

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank You.

Harshitha.

Community Support Team.

[v-hjannapu]

Hi @Johann80 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please Accept it as a solution so that other community members can find it easily.

Thank You.

Harshitha.

Community Support Team.