Hiding Visuals In PowerBI Based on Number of Rows

[HEADS]

We have several dashboards in PowerBI and we want to hide certain graphs/charts if there isn't at least 5 rows of data (for privacy concerns). I have created a measure to check this condition. Now we currently use Card components to display a message based on this measure to tell users their filters are too selective and they need to lessen the criteria. We have also connected our actual tables/graphs to this measure as a filter so that users don't see any data. However, we'd prefer to have the tables/charts completely hidden so that we could display more information to the user about why this is necessary/happening instead of all the blank space. Here is what we currently end up with:

I was able to have a Card component overlay that could do this and become transparent so users could see the data in the tables/charts when we have more than 5 rows of data but we lose the ability to click into the tables/line graphs. The card component can become transparent but not allow the user to click through it into components beneath.

Has anyone tried to accomplish something similar and if so how were you able to do so?

[HEADS]

Thank you, it seems similar to what I did already but let me go through it and see if it solves my problem.

[Anonymous]

Hi @HEADS,

Is there any progress on this issue?

If you find any answer is helpful to you, please remember to accept it.

It will help others who meet the similar question in this forum.

Thank you for your understanding.

[parry2k]

@HEADS I have something similar here and that should work for you;

Color transparency and conditional formatting is VERY powerful Part 1 - Power BI

Conditional Formatting and Transparency to develop user friendly reports Part II - Power BI