How to navigate between pages and apply filters using interactions

Hey there!

You can use buttons and drill-through filters to navigate and maintain filters between pages. Here's how:

1. Go to Page 2 in Power BI.
Add a Drill-through Filter:
Drag the Category field into the Drill-through Filters pane.
Enable "Keep all filters" (if needed).
Design Page 2 with the required chart/visuals.

2. 

Apply Drill-through from Page 1

On Page 1, select the bar chart.
Right-click on any bar (Category A, B, etc.) → Choose Drill-through → Select Page 2.
This action will navigate to Page 2 with the selected category applied as a filter.

3. 

Enable Navigation Using Buttons (Optional)

If you want to use a button to navigate, follow these steps:

Add a button to Page 1 (Insert → Buttons → Blank).
Select the button → Action pane → Choose Page Navigation → Select Page 2.
To pass filters dynamically, ensure you have a drill-through filter on Page 2.

Hopefully this works!

😁😁

Hi Lora_0121 

You can use a drillthrough page to navigate to another page with the filters applied and use a bookmark that saves the state of a page without filters to clear the filters.

Please see the attached sample pbix.