Forum Discussion
Z_BI
4 years agoFrequent Visitor
Complementary filter
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 ...
- 4 years ago
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
bcdobbs
4 years agoCommunity Champion
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