How to sort the values in parameter drop-down menu in Power BI Paginated Report?

Gian 0 Reputation points

I have a text parameter in a Power BI Paginated Report, but the order of the drop down parameter values is scrambled.

How to sort the values in parameter drop-down menu (NOT result values) to be in ascending or descending order?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,555 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
30,387 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,093 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AniyaTang-MSFT 9,681 Reputation points Microsoft Vendor

    Hi @Gian

    I found this link for you: You can try to modify the dataset model or modify the query.

    In fact, I don't know much about Power BI. If the above methods cannot solve your problem, I suggest you to seek help from the Power BI community:

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,


    0 comments No comments