Month Year Sorting Issue with my report

[dinesharivalaga]

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

[ChiragGarg2512 · Accepted solution]

@dinesharivalaga 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.