Forum Discussion

shanemc1's avatar
shanemc1
Frequent Visitor
7 years ago
Solved

Apply the same data in 2 separate slicers which will filter 2 separate Matrix's on the same page - P

I have the following report in power BI. It shows the different stages an enquiry can be at.    I want to show the data in two separate matrix's with two separate RecordCreated slicers filtering it...
  • yelsherif's avatar
    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