User Profile
JManfredini
Regular Visitor
Joined 3 years ago
User Widgets
Contributions
Is there a way to display a category count as "less than #" if the count is less than a value?
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): Year Race Count 2020 White 189 2020 Black 27 2020 Asian 89 2020 Other 2 2019 White 234 2019 Black 54 2019 Asian 4 2019 Other 6 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?Solved1.6KViews0likes2Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.