Power BI Report Builder And/OR parameters

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:

1. 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.

2. In the report visualization (table, matrix, etc.), go to the "Visualizations" pane and select the "Filters" option.

3. In the "Filters" pane, add each parameter as a filter and set the filter type to "Advanced".

4. 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.

5. Repeat the steps for each parameter and filter combination that you want to allow the end user to control.

6. 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.