Forum Discussion

NithyaKB's avatar
NithyaKB
Icon for Helper I rankHelper I
4 years ago

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

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 th...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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