Power BI Report Builder Parameter and Dataset Filter

[DST_]

Hi,

I am trying to create a Power BI Report Builder Parameter but need some assistance.

I am using 'Specify Values' to type as follows:

Test Required

Dev Required

UAT Required

In my dataset I have a GUID and 3 columns which are boolean yes/no;

GUID
Test Required

Dev Required

UAT Required

So I need to set up the dataset filter so that if I select the parameter Test Required and in the data the Test Required field = "Yes" I see that data.

And if I choose the parameter Dev Required and in the data the Dev Required field = "Yes" I see that data etc...

Any assistance in how to write the expression would be great.

Thanks

[v-nuoc-msft]

Hi @DST_

For your question, here is the method I provided:

You can create report parameters in a few different ways.

Add a dataset query that contains variables or a dataset stored procedure that contains input parameters. A dataset parameter is created for each variable or input parameter, and a report parameter is created for each dataset parameter.

Create a parameter manually from the Report Data pane. You can configure report parameters so that a user can interactively enter values to help customize the contents or appearance of a report. You can also configure report parameters so that a user can't change pre-configured values.

And the boolen type only has true or false, but if you want to use yes or no you can consider the text type.

You can view the link below for more details:

Report parameters in Power BI Report Builder - Power BI | Microsoft Learn

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.