Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Power BI Report Builder Parameter and Dataset Filter

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

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.