Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a button on my dashboard that toggles btw two pages. The two pages are very similar, and each page has a filter by organization (8 choices). If, say, on page 1 I choose to look at th data of the 5th oranization, when I click the button to go to page 2, the filter resets back to choice 1. Is there a way to set it so that the filter stays the same when I hit the button (fix the filter)
Solved! Go to Solution.
See attached .pbix file with an implemented working solution.
-IF you were talking about having a slicer on both pages that stays synchronized and is unaffected by selecting "page" bookmarks, then use all of the following directions.
-IF you were just talking about having a "page-level filter" in the filter panel that doesn't reset when you switch from page to page, then only do the bookmark part where you de-select "data" from the bookmark that switches between pages. This will prevent the page bookmark from re-setting your filter settings.
That being said, here you go:
Copy and Paste the slicer from one page to the other. It will ask you if you want them to stay synchronized, select "Sync". There might be a different way to get the two filters sychronized, but this is one way I know of.
Also, make sure that the bookmarks that switch from one page to the other do NOT have "Data" selected. Only "Current Page" should be selected.
///Mediocre Power BI Advice, but it's free///
Hi @daniel_krantz_4 ,
Thanks for the reply from @kpost .
Just drag the fields you want to filter to Filter on all pages.
For example, in my sample data, drag the Product field to Filter on all pages and select SKU1, SKU2, SKU3, the effect of different pages is as follows:
For more information about Filter on all pages see:
Add a filter to a report in Power BI - Power BI | Microsoft Learn
If you have other questions please feel free to contact me.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
See attached .pbix file with an implemented working solution.
-IF you were talking about having a slicer on both pages that stays synchronized and is unaffected by selecting "page" bookmarks, then use all of the following directions.
-IF you were just talking about having a "page-level filter" in the filter panel that doesn't reset when you switch from page to page, then only do the bookmark part where you de-select "data" from the bookmark that switches between pages. This will prevent the page bookmark from re-setting your filter settings.
That being said, here you go:
Copy and Paste the slicer from one page to the other. It will ask you if you want them to stay synchronized, select "Sync". There might be a different way to get the two filters sychronized, but this is one way I know of.
Also, make sure that the bookmarks that switch from one page to the other do NOT have "Data" selected. Only "Current Page" should be selected.
///Mediocre Power BI Advice, but it's free///
Ah thanks! Didn't realize I had to copy-paste the filter separately from when I was copying whole pages. It works now
You're welcome! There might be a better way to synchronize filters that already exist in a built-out report page, but this is how I do it when creating from the ground up.
Happy data mining.
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |