Changing Chart to Calendar month order

[jbrines]

Hi All,

Thanks to @BeaBF I have a great report for my helpdesk statisticts, I just need it to display charts in a calendar month order, as you will see below it is doing it in a strange order.

Thanks

J

[MasonMA · Accepted solution]

Hi, 

As other users mentioned, the ideal way would be to add a 'Month Number' column in your table and then Sort your Closed Date column by Month Number. This way Month Name Column in your visual will be sorted by Month number instead of the alphabetical way. 

Alternatively, since you've enabled 'Auto Date/time' in Option, you can also Drill up and then Expand all down one level, it will also give you the correct sort order. 

[cengizhanarslan]

• Go to Data view

• Select the Month Name column

• In the ribbon → Column tools

• Click Sort by column

• Choose Month Number

[krishnakanth240]

Hi @jbrines 

In your Date table, you can create a Month Number column
MonthNo = MONTH([Date]).Select the Month Name column from the table. Go to format tab - Sort by column and choose MonthNo

[FBergamaschi]

Hi @jbrines 

click con the ellipses on the top right corner and select sort by month and then ascending

By the way are you sure you have a single year?

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI