Months not in chronological order in Visual

[Anonymous]

Hi All,

I am a beginner trying to work with POWER BI DESKTOP.

I am trying to show a monthly trend of claims paid however, the months are not shown in the axis title in chronological order. Can you help with where am I going wrong?

Thanks,

Bhamini

[Fowmy]

@Anonymous 

You need to create an additional column with month number like MonthNumber = MONTH(table[date]) then select the Month Processed column, go to Modeling Tabl, Sort by Column choose the new column Monthnumber

https://cebrusa.com/2019/10/08/power-bi-sort-by-month-name/

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

Hi Fowmy,

I tried following the steps you shared but weirdly it keeps showing this error when I add a custom column and write the formula =MONTH(Table[date]).

Please tell me how can I fix this.