Visual level filter from one viz affecting other viz

[flipacoin]

Hi!

I have a matrix and a table on the same page.

The matrix has the field Sites as rows, and some measures as values, and a visual level filter on date.

Clicking on a row(site) in the matrix I want the table to be filtered by this choice of site, and it does.
However, in addition to the selection of site, the visual level filter on date (which should only apply for the matrix) seem to affect the table as well.

Yes, the date filter is under "filters on this visual" and the table is not affected by this before I do a selection in the matrix.

How can avoid this transfer of visual level filter?

Thank you in advance

[Ashish_Mathur · Accepted solution]

Hi,

Does anything change (for good) with this modification?

1. Create a slicer for Date
2. Remove it from the Filter pane
3. Turn off interaction between the Date slicer and the Table visual

[flipacoin]

Oh, didn't think of this! Thank you, it worked!

[Ashish_Mathur]

You are welcome.

[Idrissshatila]

Hello @flipacoin ,

You could prevent this using Edit interactions, check it out here https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=p...

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[flipacoin]

I don't believe editting interactions will achieve this. I still want the selection of site in the matrix to affect the table. Just don't want the visual level filter on date from the matrix to affect the table.

Editting interactions only allows me to choose between None and Filter, not choose which of the filters should be considered in the interaction.