Forum Discussion
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 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!
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 ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
- v-lionel-msft
Community Support
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 ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.