Forum Discussion
Advocate IIIChanging Chart to Calendar month order
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
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.
4 Replies
- MasonMA
Super User
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.
- 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
- 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 - cengizhanarslan
Go to Data view
Select the Month Name column
In the ribbon → Column tools
Click Sort by column
Choose Month Number
