Complementary filter

[Z_BI]

Hi there , I have these 2 matrix (same data inside) and i would like to know if there is the possibility to have 2 filters (on week number), one should be the complement of the other.
My goal is to have :
One filter where i could select week , for example , week 44 and 45.
Other filter where i could select week 46, 47 and 48.
Obviusly , the relative matrix will be updated.

One matrix will have data for weeks 44/45 and other matrix data for weeks 46/47/48.

[bcdobbs · Accepted solution]

Certainly!

You need to use "edit visual interactions". You can set one slicer to only filter matrix 1 and the other slicer to only filter matrix 2. 

Have a look at https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions