Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Month Year Sorting Issue with my report

Hi All ,

 

My visuals having an issue with monthyear sorting after September Month (Month Index 9) , after October month refresh it got changed the order like below (after month index 9 , Power Bi taking 10 as a starting and changed the order) , i am displaying last 4 months data in the visuals so that it looks like this , Jan to Sep no issue ..

 

 

DAX --> Month Format = FORMAT('R2A GL Lease Acc_New'[MonthYear],"MMM-YY")

 

 

It will change the order back automatically when Jan 2024 refresh done but we have to fix this now and i am using the Month Index column sorting as well .. Is month Index only applicable for Month Column alone ? If true then what would be the fix for my issue ? Please help to sort this out asap .

 

TIA
Dinesh

General Comment
Need Help
Tutorial Requests
  • ChiragGarg2512's avatar
    ChiragGarg2512
    2 years ago

    Anonymous Chnage the month index data type to number and sort on the basis of month index. This is happening because the text "10" and "11" comes before string "8" and "9". So according to text the order is correct.

    Change the datatype to number.

     

1 Reply

  • ChiragGarg2512's avatar
    ChiragGarg2512
    Icon for Solution Sage rankSolution Sage
    2 years ago

    Anonymous Chnage the month index data type to number and sort on the basis of month index. This is happening because the text "10" and "11" comes before string "8" and "9". So according to text the order is correct.

    Change the datatype to number.