Fix dropdown of month and year in Power bi desktop

[RajMalhotra1984]

Hi This is how I see my month year selection how to I fix this data has multiple lines with month year.

[amitchandak · Accepted solution]

@RajMalhotra1984 , seem like you just change the format of the date, which is causing the issue. It is still date inside.

Create a new column

Month Year = FORMAT([Date],"mmmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")

mark second one as sort column of first one