Reply
Frequent Visitor
Posts: 9
Registered: ‎12-28-2018

Multiple Slicers for Multiple Tables

I have multiple slicers, have have visuals from 2 different tables.

 

And both tables have the columns that the slicers represent

 

Slicers.JPG

 

What can i do so all slicers work for all charts?

 

thank you so much

Established Member
Posts: 267
Registered: ‎02-01-2018

Re: Multiple Slicers for Multiple Tables

[ Edited ]

So if I got that right, you have two different queries populated from two different tables and the slicers that you have are sourced from both these tables? And you want your slicer selection to impact all the visuals irrespective of which table they are from?

 

If the above is true, you need to have a relationship set between both your tables first, once you have that set the slicers will slice the data for all visuals from Table 1 and Table 2. Also, you can set the interaction of the slicers with the visuals by selecting the slicer and then going to the Format option on the top window pane and clicking on Edit Interactions.

Frequent Visitor
Posts: 9
Registered: ‎12-28-2018

Re: Multiple Slicers for Multiple Tables

Hello @nirvana_moksh

 

The slicer are made from table 1.

 

but the table 2, have the same columns shown in the slicers.

 

they have a relationship between these 2 tables already:

 

relations.JPG

 

but the slicer "tecnologia" are working, because its from the ative relation.

 

The other slices dont work at all. Smiley Sad

Established Member
Posts: 267
Registered: ‎02-01-2018

Re: Multiple Slicers for Multiple Tables

Hmm and you do have the bi-directional relationship on as well, the other 'not working' slicers, can you click on that and see what is the interaction with the other visuals? As a test, you can also duplicate the page and populate the not working slicer with the column from Table 2 and see what the behavior is to troubleshoot this issue.

Community Support Team
Posts: 1,343
Registered: ‎07-25-2018

Re: Multiple Slicers for Multiple Tables

Hi @VanessaAG

 

It seems you may create filter tables like Table = DISTINCT(Table1[Column2]) and Table 2. Then link them with other 2 tables as below to filter Table1 and Table2. Then use Table and Table 2 as slicers.

1.png

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Posts: 1,343
Registered: ‎07-25-2018

Re: Multiple Slicers for Multiple Tables

Hi @VanessaAG

 

Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here. 

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor
Posts: 9
Registered: ‎12-28-2018

Re: Multiple Slicers for Multiple Tables

[ Edited ]

Hello @v-cherch-msft, Happy New Year

 

thank you for the reply .

 

You say i should made a table for each column, each slicer use?

Frequent Visitor
Posts: 9
Registered: ‎12-28-2018

Re: Multiple Slicers for Multiple Tables

@v-cherch-msftI was on vacations for the holidays, couldnt test.

 

Im doing it today. I will tell if it works Smiley Happy

Highlighted
Frequent Visitor
Posts: 9
Registered: ‎12-28-2018

Re: Multiple Slicers for Multiple Tables

 

 

Hello @nirvana_moksh, the intereactions of the other slicers are this:

 

interaction.JPG

 

I tried what you said, and they dont work. I have to make slicers from table2 to make them work. But then they dont work with table1