Problems with Slicers

[Rigolleto]

Hi,

I am having problems with two slicers, let me explain you and see if somebody can help me

how cann you see I have choosed, fig 1, one department and one Buyername, in the bottom you can see that the grid was populated, perfect!!, the issue is when I choose the next department, see fig 2, you can see that the grid values are gone, I was able to identidy the issue, the issue is that in the previous selection I left the Buyername selected, if I back and remove it then the grid is populated, well here is my request, if somebody knows about a solution:

1. Is there a way to remove the selection of the Buyername when I do choose a new department? in that way I will able to choose a new department and show the data

[v-yuta-msft · Accepted solution]

@Rigolleto ,

So are the two slicers based on the different columns in different tables, if they are based on different tables, you can disable the relationship between the two tables and then disable the slicer interaction with each other by clicking Format-> Edit Interaction.

  

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.