Sort dates in month order for bar chart visual

[Elisa112]

Hi Experts 

I am trying to sort my visual into the correct month order (ascending by month).  I have data from Sept 2023 onwards. The 2023 months are in the correct order however not for 2024. See below

I'm probably missing something very simple, any advice greatly received.

thanks in advance

[miTutorials · Accepted solution]

Watch this short tutorial to sort months on the Column chart.

How to Sort Months the right way in PowerBI | Bar Chart | MI Tutorial - YouTube

[Elisa112]

Thank you @miTutorials 

[PhilipTreacy]

Hi @Elisa112 

Download example PBIX file

I suspect your 'date/month' column is actually text and in your chart it is sorting alphabetically in descending order S -> A

You need to use a proper date column like this

The data will then sort correctly

Phil

[Elisa112]

Hi @PhilipTreacy 

thanks for your assistance, my tables looks like this:

I also have a customer table with dates such as (referral date, start date). So I created a measure to calculate the total customers but the visual shows the months in the wrongorder. I have tried creating a sorting column on my customer table but I get the following error when I try this solution

Any further help much appreciated.

Elisa112

[fahadqadir3]

@Elisa112 You can sort the months by using the following calculated column:

Sorting Condition = - ( YEAR('Table'[Date])*100+MONTH('Table'[Date]) )

Sort the month by sorting condition:

Power BI file attached:

Sorting.pbix

Regards,

Fahad Qadir

Did I answer your question? Mark my post as a solution!

[Gabry]

Hello,

what columnd did you put on the x axis? Like month? You have to sort that column by date.

If it's a column from the calendar table.

You go in the dataview, then select the month column, than select order by date, if you can't order by date you need a month number column and then you sort by month number. Hope I made my point