slicer by an index table created

[koorosh]

Hi experts,

Why the slicer does not work on the matrix table?

Regards

Koorosh

[FrankAT]

Hi @koorosh ,

in my point of view the slicer works as expected (see figure 1 without any selection, figure 2 with Partner_3 as selection in slicer):

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[koorosh]

Hello, please check the following image. On the left matrix, the slicer took from partner from Partner table and on the right matrix slicer took from partner from sheet1 table. As you see the result is not the same.?!

Since I would have other tables on the report that has relation with the Partner table, I just need to filter the matrix by partner in Partner table

[FrankAT · Accepted solution]

Hi @koorosh ,

I don't know if my following explanation is correct. Use it as a hint.

The resultand behavior of the matrix using the two slicers is different. The sliccer with Partner from Partner table works with filter propagation over the relationship, the matrix shows all rows. The second slicer with Partner from Sheet1 table filters the table Sheet1 directly.

I added a second measure. It "synchronizes" the behavior of the matrix:

Measure 2 = IF(SELECTEDVALUE(Sheet1[Value]) = "T" , "✅" , BLANK())

Take a look at the attached PBIX file.

Both, the yellow and the blue part, have their own behavior. Nothing is wrong!

It is in your hand to choose which you want to use.

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)