To achieve the desired behavior where selecting a value in the "Region" slicer automatically sets the "Business Unit" slicer to "All" without the need to press a bookmark button, you can use the "Edit Interactions" feature in Power BI. Here's how you can set this up:
Create a Slicer for Region:
First, make sure you have a slicer for the "Region" field in your Power BI report.
Create a Slicer for Business Unit:
Create a slicer for the "Business Unit" field in your report. By default, it will show all the available values for "Business Unit."
Access Edit Interactions:
Go to the "Format" tab in the "Visualizations" pane, and click on "Edit interactions."
Set Interactions:
You'll see a set of icons next to each visual on your report page. These icons represent the interaction between visuals.
Click on the icon next to the "Region" slicer.
In the menu that appears, select the option to "Filter" the "Business Unit" slicer.
This step ensures that when you select a value in the "Region" slicer, it filters the "Business Unit" slicer accordingly.
Default "Business Unit" Slicer to "All":
By default, the "Business Unit" slicer will show all values. You don't need to set any specific interaction for it because it will show all values unless filtered.
Now, when you select a value in the "Region" slicer, the "Business Unit" slicer will automatically update to show "All" values. This is because the "Business Unit" slicer is filtered based on the selection made in the "Region" slicer.
