Forum Discussion
Matrix acting like Slicer?
I got two different matrixes in my Dashboard. Matrix1 displays the different products (iPhone 11, iPhone 12,...) and Matrix2 displays the telephone numbers of those specific products. So Matrix2 is depended on Matrix1.
The problem is when I click on a device in Matrix1 and then on a telephone number in Matrix2, Matrix2 simultaneously forgets the slicer function of Matrix1 and switches backt to displaying the telephone numbers of all phones. I already changed the interactions of Matrix2 to it not being dependend on other filters but that doesn't change anything.
How can I prevent this? I want it to act like a slicer.
Hi, Anonymous ;
This is not supported, and it is by design. The slicer is used to filter data, but when we click on the A product in matrix1, only A is highlighted in the matrix; it is possible to filter Matrix2; but when we click again in matrix2 A, which also highlights the A product of matrix2, will filter matrix1, but it cannot just filter data like a slicer;
and if the slicer.
so we could find the difference of slicer and the matrix.
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-reports-filters-and-highlighting
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Anonymous , select matrix one and then switch off interaction with Matrix 2.
Select Matrix 2 and then switch off interaction with Matrix 1. Then it should work
How Interactions Work- Split Page using interactions to compare - https://youtu.be/GIfRKzhMaR4
Hi, Anonymous ;
This is not supported, and it is by design. The slicer is used to filter data, but when we click on the A product in matrix1, only A is highlighted in the matrix; it is possible to filter Matrix2; but when we click again in matrix2 A, which also highlights the A product of matrix2, will filter matrix1, but it cannot just filter data like a slicer;
and if the slicer.
so we could find the difference of slicer and the matrix.
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-reports-filters-and-highlighting
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
