How to blank out all visuals when filtering results in count less than 5

[jos818]

Hi, I'm looking to blank out all visuals on screen if the user has applied various filters on the pane that results in total customer count less than 5. This is just one way to suppress data if the count falls below a threshold but open to other suggestions to how to approach this ensuring the user will not be able to filter down too narrow a search.

Can one assist?

Thanks in advance

[danextian]

hi @jos818

You can make all the measures in the visuals used in a page to return blank if customer count is less than 5.

[123abc · Accepted solution]

plz downlaod follwong pbix file:

https://drive.google.com/file/d/1iCD4AF85lpcV4Kxv2i9g4iSOnIKlu7nC/view?usp=sharing

Apply Conditional Formatting:

• Select the card visual.

• Go to the Format pane.

• Find the Data colors or Background option.

• Use the fx button to apply conditional formatting.

• Set the rule to use the ShowVisuals measure. If ShowVisuals is 0, set the color to white or transparent.

I think we cant backuout to table visule.

Is your issue is solved:

if yes mark is as a soluiton so that other can get benefit from it.