Hiding visuals that reflect a small data population

[crost]

Hi Folks,

I'm building a suite of HR dashboards and a very specific use case is coming up based on the needs of my organization: focusing most closely on protected characteristics, we need our diversity charts to either null out or be hidden when the population reflected in them gets to be too small (less than 8 is what our Director of Diversity has asked for). Since many of these dashboards are designed to be able to break teams out by, say, office location, team, or manager, they are very fluid in how big and small the population they are displaying is at any given time based on what filters are activated by the end user. 

Working with a more senior member of the team, we tried setting up a shape that might appear only when a measure was less than 8, blocking the visuals in question, but as far as we've been able to work out, Power BI doesn't have the capacity to render transparency of a visual conditional (there is conditional formatting for colors, but those color palates don't include a "no fill" selection option).

Any thoughts on how we can achieve this? It's of vital interest to our stakeholders.

[crost]

Thank you! I'll probably have to play around with the first one. My concern is in layering the measure upon measure, it might be hard to provide dimensional data, but if it's possible then that seems like the best solution. Sadly these are not static reports, so it needs to be something that's dynamic based on end-user interaction. 

My R is very basic, but this might be an opportunity to buff it up if the above doesn't work. 

[Deepak_22]

Hello @crost , Achieving your goal of hiding or nulling out visuals in Power BI when the population is below a certain threshold can be a bit tricky.However, there are some workarounds that might help you.

Use Custom Measures for Visibility:

Create a measure that checks if the count of the population is less than 8.

If it's less than 8, the measure should return a blank or null value.

Use this measure in your visual. When the measure returns a blank or null, the visual will not display any data.

For instance:

Measure Visibility = IF(COUNTROWS(Table) < 8, BLANK(), [Your Original Measure])

Leverage Drillthrough:

If a visual is clicked and it drills through to another report page with more details, consider adding a condition in the drillthrough filter. If the condition isn't met (e.g., count < 8), the drilled report won't display relevant data.

Use Text Boxes:

Instead of using shapes to block visuals, consider placing a text box with a message like "Insufficient Data" when the count is less than 8. This approach is more informative for the end user. You can't hide/show text boxes dynamically, so this is a manual workaround if your reports are static or if you review them before sharing.

Custom Visuals or R/Python Integration:

Power BI allows integration with R and Python visuals. If you're familiar with these languages, you can create a custom visual that will behave exactly the way you want it to when the count is below the threshold. This, however, requires programming knowledge and might be more resource-intensive.

If you find this helpful, please provide a kudo and mark it as an accepted solution.