Forum Discussion

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
2 years ago

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's avatar
Elisa112
Icon for Helper V rankHelper V
2 years ago

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