cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
VanessaAG Frequent Visitor
Frequent Visitor

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

8 REPLIES 8
nirvana_moksh Established Member
Established Member

Re: Multiple Slicers for Multiple Tables

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.

VanessaAG Frequent Visitor
Frequent Visitor

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

nirvana_moksh Established Member
Established Member

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.

v-cherch-msft Super Contributor
Super Contributor

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.
v-cherch-msft Super Contributor
Super Contributor

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

Re: Multiple Slicers for Multiple Tables

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?

VanessaAG Frequent Visitor
Frequent Visitor

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

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

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 91 members 1,508 guests
Please welcome our newest community members: