Reg : Power BI Paginated Report builder (Parameter values with hiphen(-) not getting sorted)

[NithyaKB]

Hi,
Please help me how to sort a number with dash in drop down values of a parameter in Power BI Paginated Report Builder.

I have a column with hiphen as shown above.When I try sorting the column it gets sorted except for the double digit number after hiphen . 
For example in above screenshotthe values from 2021 - 9 till 2021 - 2 gets sorted descending order but 2021-10 , 2021-11, 2021-12 is not getting sorted . I need an output as below
2021-12
2021-11
2021-10
2021-9
2021-8
...

Below is the query for the parameter
EVALUATE SELECTCOLUMNS (ADDCOLUMNS (SUMMARIZECOLUMNS (ROLLUPADDISSUBTOTAL ('Query1'[periodfilter], "h0"), RSCustomDaxFilter(@Query1cmpcode,EqualToCondition,[Query1].[cmpcode],String)), "ParameterLevel", if ([h0], 0, 1)), "ParameterCaption", SWITCH([ParameterLevel], 1, "" & 'Query1'[periodfilter], "Blank()"), "ParameterValue", "" & 'Query1'[periodfilter], "ParameterLevel", [ParameterLevel], "'Query1'[periodfilter]", 'Query1'[periodfilter]) order by 'Query1'[periodfilter] DESC, [ParameterLevel]

[Anonymous]

Hi @NithyaKB ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

[Anonymous]

Hi @NithyaKB ,

Since the values are identified as Text type, they are in alphabetical order... Is it possible to change the drop down values with the below formats(when the month number is less than 10, then add the prefix "0")? 

2021-09

2021-08

2021-07

2021-06

2021-05

...

Best Regards