topic Power BI Report Builder And/OR parameters in Report Server

Power BI Report Builder And/OR parameters

PenelopePitstop — Wed, 01 Feb 2023 13:35:35 GMT

Hi, I'm new to Power BI and am currently looking at how I can use Report Builder to provide end users the options to filter the datasets using combinations of parameters but with the flexibility of being able to toggle between AND and OR in some way. Is this possible and if so, how (without having to edit the query each time)? Thanks

Re: Power BI Report Builder And/OR parameters

jaweher899 — Mon, 06 Feb 2023 09:27:12 GMT

it is possible to provide end users the option to filter datasets using combinations of parameters and toggle between AND and OR in Power BI Report Builder. You can achieve this by using the advanced filtering options available in Power BI Report Builder. Here's a high-level overview of the steps you can follow:

Add your dataset to the report canvas and create a new parameter for each filter that you want to allow the end user to control.
In the report visualization (table, matrix, etc.), go to the "Visualizations" pane and select the "Filters" option.
In the "Filters" pane, add each parameter as a filter and set the filter type to "Advanced".
In the "Advanced Filter" dialog, use the combination of AND/OR statements and the parameters to define the filter logic. For example, you can use the expression "Parameter 1 = 'value 1' AND Parameter 2 = 'value 2'" to filter the data based on the two parameters.
Repeat the steps for each parameter and filter combination that you want to allow the end user to control.
Publish the report to the Power BI Service and test the filters to make sure they work as expected.

By following these steps, you should be able to provide end users with the flexibility to filter the datasets using combinations of parameters and toggle between AND and OR in Power BI Report Builder.

Re: Power BI Report Builder And/OR parameters

PenelopePitstop — Mon, 06 Feb 2023 11:39:56 GMT

Thank you for your reply. I can see that these options are available in Power BI Desktop, but I'm struggling to find them in Power BI Report Builder. Would you be able to provide some more detail and/or (pardon the pun!) screenshots?