Field Parameter and sorting

[PowerRon]

Hi,

I have this field parameter

I have this Field Parameter

FP_YearMonth = {

    ("Year", NAMEOF('Calendar'[Year]), 0),

    ("Month Year", NAMEOF('Calendar'[Month Year]), 1)

}

Month Year are values like 'Dec-2018, Jan-2019'

I use this in a visual. When I choose Month-Year it gives the data in ascending order, because Mont-Year is sorted by column Year-Month (201812, 201901 etc) 

When I click on Year, it constantly makes a mess on the sorting order

How can I fix this?

Regards
Ron

[PowerRon]

thnx @Igna 

[Igna · Accepted solution]

Hello,

You have to sort by another column. Look here : https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-deskto...

Hope it helps

Igna