Forum Discussion

gblanks's avatar
gblanks
Frequent Visitor
2 years ago
Solved

Power BI Paginated Report have one parameter effect the available selections of another parameter

Hello, I have a very specific thing that I want to do within Power bi paginated reports, and I can't seem to find any way of doing it. Specifically, I want to have two separate parameters: a "Project...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, gblanks 

     

    Based on your description, you want to create two parameters in a paged report and one of the parameters can influence the selection range of the other parameter, Cascading Parameters in a paged report meets your needs. You can define a set of related parameters so that the list of values for one parameter depends on the values selected in the other parameter. For example, the first parameter is independent and might display a list of product categories. When the user selects a category, the second parameter depends on the value of the first parameter. Its value will be updated using the list of subcategories in the selected category. When the user views the report, the values of both the category and subcategory parameters are used to filter the report data. Please refer to the official documentation for details on how to do this.

    Configuring cascading parameters: Add cascading parameters to a Power BI paginated report - Power BI | Microsoft Learn


    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum