Forum Discussion

HEADS's avatar
HEADS
Regular Visitor
1 year ago

Hiding Visuals In PowerBI Based on Number of Rows

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?

 

3 Replies