Slicer Syncing with Relationship between filters

[Apoorv_Lunawat]

Hey everyone,
 
 I have a query on how to sync two filters on two pages.
 I have two pages with two different slicers let's say Filter-X and Filter-Y from different sources.
 Filter-X:                    Filter-Y:
 A                            L
 B                            M
 C                            N    
 D                            O
 E                            P
 
 What I want over here is that if I Filter value 'A' on page 1, My filter value should change to corresponding-value*  'L' in Page 2 (Filter Y).
 Now when that happens all the other Filter-Y values should also be present And vice versa

I tried to create a relationship between them by using an index value, and then joining them in the model.
But all the other filters disapper when I select a particular value.

(*This is how I want my filters functionality to be:
A<==>L
B<==>M

C<==>N

D<==>O
E<==>P)

@amitchandak 
@parry2k 
@Greg_Deckler 
@Cmcmahan 
@Icey 

[v-jayw-msft]

Hi @Apoorv_Lunawat ,

Make sure slicer x and slicer y are in same table. if not, do as @Greg_Deckler  said create a new table.

Once you configured sync slicer x in page1, first make it visable in page2.

Then edit the interactive in page2 to none as below.

Then make the slicer x invisable in page2 and the job down.

Pbix as attached.

Best Regards,

Jay

[Greg_Deckler]

@Apoorv_Lunawat - Seems like you could create a table like this:

Column1,Column2

A,L

B,M

C,N

D,O

E,P

Relate this table to your other 2 tables. Use the columns from this table in your slicers. Should work across pages as long as you have sync slicers for all your slicers.

[amitchandak]

@Apoorv_Lunawat , not very clear. Refer if this can help

https://www.youtube.com/watch?v=cyOquvfhzNM

[Apoorv_Lunawat]

Hey @amitchandak 
I have created a Dummy Pbix file with the following two tables,

They should be connected on Country Code in the model view, having a Bi-Directional Relationship as shown-






Now, The functionality that I am looking for here is :
1) If country India is selected , City should filter to be India and I can see all the other values in the city filter as well.

2) If the city filter is selected as london, I should see UK as the country filtered. And I have an option to select the other values in country filter as well.


Thank you 🙂
 

[amitchandak]

@Apoorv_Lunawat , seem like you got the solution?

[Apoorv_Lunawat]

Hey Amit,
These were just place holders to show what functionality is required.
It's still not achieved!