Forum Discussion
Multiple Parameters in Report Builder
I am working on Report Builder Paginated Report. I have three parameters Company Name, State and City
When I select the value for the State ( just one parameter) it asks me to input the value in the rest of the parameters also then only I can view the report.
Is there any way I can use the single parameter without inputting the value in the other two parameters?
Thank you
Hi BishwaR ,
Cascading parameters provide a way of managing large amounts of data in a paginated report. You can define a set of related parameters so that the list of values for one parameter depends on the value chosen in another parameter. For example, the first parameter is independent and might present a list of product categories. When the user selects a category, the second parameter is dependent on the value of the first parameter. Its values are updated with a list of subcategories within the chosen category. When the user views the report, the values for both the category and subcategory parameters are used to filter report data.
Check if the cascading parameters meet your needs.
Please kindly refer to this.
Use cascading parameters in paginated reports - Power BI | Microsoft Docs
Best regards,
Gao
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
1 Reply
Hi BishwaR ,
Cascading parameters provide a way of managing large amounts of data in a paginated report. You can define a set of related parameters so that the list of values for one parameter depends on the value chosen in another parameter. For example, the first parameter is independent and might present a list of product categories. When the user selects a category, the second parameter is dependent on the value of the first parameter. Its values are updated with a list of subcategories within the chosen category. When the user views the report, the values for both the category and subcategory parameters are used to filter report data.
Check if the cascading parameters meet your needs.
Please kindly refer to this.
Use cascading parameters in paginated reports - Power BI | Microsoft Docs
Best regards,
Gao
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