Share via

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

Gian 0 Reputation points
2023-08-31T21:50:26.8933333+00:00

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,918 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
39,088 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,521 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AniyaTang-MSFT 12,446 Reputation points Microsoft Vendor
    2023-09-01T01:28:38.7566667+00:00

    Hi @Gian

    I found this link for you: https://community.fabric.microsoft.com/t5/Desktop/Paginated-Report-Can-you-sort-the-parameter-dropdown-list-by-a/td-p/3265701. 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: https://community.fabric.microsoft.com/t5/Microsoft-Power-BI-Community/ct-p/powerbi.

    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,

    Aniya

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.