Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Months not in chronological order in Visual

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

2 Replies

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    5 years ago

    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's avatar
    Anonymous
    Not applicable
    5 years ago

    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.