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

[Anonymous]

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 when columns in the columns charts are selected.  I would like to hide data in all visuals whenever the client count (metrics always displayed in the visuals) drops below five given compliance reasons.  I would like all other columns to remain, but the columns with less than five should hide or say "Less than 5 clients".  

I have checked other forum posts, but can not find the exact answer I am looking for.  I do not want to only make the bar transparent as the tooltip would still appear when hovered over.

I am not able to post a sample data cut, but every transaction has one row in the data and the visuals are showing high level views by client industries, products purchased, etc.  

Thank You!

[v-lionel-msft · Accepted solution]

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.