Solved: How to filter slicer based on relationship on othe...

Oskar · ‎02-12-2023

I have two tables

Customers

Projects

If i add one Slicer control to page1 with CustomerName and another slicer on page1 with ProjectName.

Since the tables have a relationship, the project-slicer filters and shows only projects for the selected customer.

Great!

But now i want to put the project-slicer on another page.

But then the slicer on page2 with projects does not filter based on the cutomer selection i am doing on page1.

Why?

aj1973 · ‎02-12-2023

You will need to synchronize your slicers between pages.

May the easiest and fastest way is to copy/paste the slicer from page to page, Power BI will then ask you if you want to synchronize.

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

aj1973 · ‎02-12-2023

You will need to synchronize your slicers between pages.

May the easiest and fastest way is to copy/paste the slicer from page to page, Power BI will then ask you if you want to synchronize.

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Oskar · ‎02-12-2023

Thank you for that. I had found the copy/paste thing... but could not accpet that that was the only way. Now i found the settings aswell. Thanks!!

How to filter slicer based on relationship on other pages?