Parameter Power Bi report Builder

[Tuan_BA]

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. 

[v-yangliu-msft · Accepted solution]

Hi  @Tuan_BA ,

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.