Sort a dynamic text column (Month Year)

[Alisea_MI]

Hi!

I have a dynamic text column containing Month + Year (6 previous moths data).
The column is current being sorted as text by month name.
  
How can I sort it by Year - Month? I have no other date column to sort it by.

Many thanks in advance!

[ribisht17 · Accepted solution]

@Alisea_MI 

Step 1

Create a duplicate column

Step 2

Replace Mars with Mar, Februari with Feb so on

Now you get a date column with Step 2, now sort on this

Regards,

Ritesh

[Arul]

@Alisea_MI ,

try to create one calculated column using beolw dax,

Monthyear sort = FORMAT(financials[Date],"YYYYMM")

and then sort the above column by using sortby column option.

Thanks,

Arul

[ribisht17]

@Alisea_MI 

An elegant solution is to create a date bin. You do this by

1. Right click on data field (make sure it's a date type)
2. Select 'New Group'
3. Create Bins (could be more than one month if you wish)
4. choose the new bin for your 'shared axis' in the Report View
5. win

>>>> how to sort Date (MonthYear column)? - Microsoft Power BI Community

Regards,

Ritesh

[Alisea_MI]

Hi, @ribisht17 ! Thanks for you idea! Unfortunately I could change it to a date - the months are in Swedish and it didn't work.