Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Slicer dropdown to filter area data and hide rows in Matrix

Hello to all,   When using a slicer dropdown to filter data, let's consider a scenario where there are 5 Multi Areas (A, B, C, D, and E), each having 4 districts, resulting in a total of 20 distric...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    I created a workaround using this DAX and it solved my problem

    CF = IF(HASONEVALUE(Tab1[Dist]), BLANK(), 'Tab3'[M1])
     
    THANKS Anonymous  Anonymous  for the support.
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  Anonymous ,

 

You can try it by following these steps

1. Format – Row headers – Options – Stepped layout set off.

2. Column subtotal and Row subtotals – set off.

3. Place the fields into the matrix as follows.

[Area] and [District] --  Rows

[M1],[M2],[M3]and[M4] -- Value

4. Result.

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.