Forum Discussion
Apply the same data in 2 separate slicers which will filter 2 separate Matrix's on the same page - P
- 7 years ago
It is easy to replicate the tables in power BI, e.g. in the modeling tab, select "table" and write something like ReplicateTable = Table1.
The replicate table will not be linked to the model by default, but you can do this if needed in the relationship view.
Now you can set up new slicer that is dedicated only for the new replicate table and use it as mentioned in your post.
you can alternatively use the same table with 2 matrixes, create two slicers, one for each matrix, then restrict the effect of each slicer to only the one matrix, so that slicer 1 affects matrix1 and not matrix2. you can find that through "format" menu
It is easy to replicate the tables in power BI, e.g. in the modeling tab, select "table" and write something like ReplicateTable = Table1.
The replicate table will not be linked to the model by default, but you can do this if needed in the relationship view.
Now you can set up new slicer that is dedicated only for the new replicate table and use it as mentioned in your post.
you can alternatively use the same table with 2 matrixes, create two slicers, one for each matrix, then restrict the effect of each slicer to only the one matrix, so that slicer 1 affects matrix1 and not matrix2. you can find that through "format" menu