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.
3,061 questions
Windows for business Windows Server User experience PowerShell
Community Center Not monitored

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    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.