Forum Discussion
Parameter Power Bi report Builder
Hi all,
I create report using Power BI Report Builder with some parameter. And now, example my parameter have 4 value is "1", "2", "3", "4". I want to include 1 other name is 'ALL' to when I choose 'ALL' in button parameter then select 4 values are ("1", "2", "3", "4").
I would like a solution from everyone.
Thank you very much.
Hi Anonymous ,
You can try the following：
Add a report parameter named ‘ALL’ and correctly set its data type to text in the ‘name’ field.
Add or modify Power BI paginated report parameters - Power BI | Microsoft Learn
Review the dataset query to include logic that checks whether the ‘ALL’ option has been selected.
Use an expression to dynamically control parameter selection based on the ‘ALL’ option."
Expressions in Power BI Report Builder - Power BI | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Anonymous ,
You can try the following：
Add a report parameter named ‘ALL’ and correctly set its data type to text in the ‘name’ field.
Add or modify Power BI paginated report parameters - Power BI | Microsoft Learn
Review the dataset query to include logic that checks whether the ‘ALL’ option has been selected.
Use an expression to dynamically control parameter selection based on the ‘ALL’ option."
Expressions in Power BI Report Builder - Power BI | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.