Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Oskar
Frequent Visitor

How to filter slicer based on relationship on other pages?

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?

 

1 ACCEPTED SOLUTION
aj1973
Community Champion
Community Champion

Hi @Oskar 

You will need to synchronize your slicers between pages.

aj1973_0-1676237763072.png

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

View solution in original post

2 REPLIES 2
aj1973
Community Champion
Community Champion

Hi @Oskar 

You will need to synchronize your slicers between pages.

aj1973_0-1676237763072.png

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
Frequent Visitor

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!!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.