Power BI Report Builder Parameter and Dataset Filter

Hi Anonymous

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.