Forum Discussion
Power BI Paginated Report have one parameter effect the available selections of another parameter
- Anonymous2 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 TeamIf 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
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