Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Hide data if visual interactions result in client count below a set threshold

Hello - I have a Power bI desktop page that has multiple visuals and cards displaying various cuts of my data file.  I have interactions turned on to allow filtering of all other visuals on the page ...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Anonymous ,

     

    You can create a measure and add the measure to the 'Filters on this visual' pane.

    All visuals wishing to hide data must add this measure to the filter pane.

    Filter = 
IF(
    COUNT(Table[client]) < 5,
    1, 0
)

     

    Best regards,
    Lionel Chen

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

     

v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

Hi Anonymous ,

 

You can create a measure and add the measure to the 'Filters on this visual' pane.

All visuals wishing to hide data must add this measure to the filter pane.

Filter = 
IF(
    COUNT(Table[client]) < 5,
    1, 0
)

 

Best regards,
Lionel Chen

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