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 could try turning off "Show items with no data".

What formula do you use for your measure?

 

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.

Anonymous's avatar
Anonymous
Not applicable
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.