Hello wonderful BI-ers,
I am working with FERPA protected data and cannot display the count of a demographic category if the count is very small, because the person/people in that category might be able to be identified.
So instead, I want to display the count of a category as "less than 5" if the count is less than five, but retain the numeric count values for categories where the count is over five. This count would be in a tooltip. In other words: when I hover over a column in my bar chart, I want to display a text value if the count is under a threshold, and a numeric value if the count is over a threshold.
Here is a sample of the data (not actual numbers):
So in this case, when I hover over the bar for [Year=2020 Race=Other], and [Year=2019 Race=Asian], Instead of the tooltip displaying "2" and "4" respecively, I see "Less than 5" (or "< 5").
I have a tooltip set up right now displaying counts in categories, what I'm asking is about displaying those values as text based on a condition.
Is this possible?