The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I'm sure this must be a common problem but I can't find the solution. I need to hide a table or visual if the combined slicer selection(s) (e.g. gender,age,department,grade,location) drop below a minimum count (e.g. 10 ) and give the User a warning as to why the table is hidden. This is so that confidentiality of very small response groups is protected when drilling down through different demographics.
I have the idea of creating two bookmarks: "Normal" and "Minimum Threshold". In "Normal" view the table or visual is shown with a simple card by the side of it that shows the current number of respondents. When the number of respondents drops below 10 for any given set of slicer selections then a "Minimum Threshold" bookmark hides the table/visual and the card changes in size and replaces the table/visual with a big warning market "Minimum Threshold - Confidentiality Protected"
I have created the bookmarks, together with the following measure for the card:
I know it's been some years, but since I was looking for a solution to the same problem I thought that my solution might help others. I've dealt with the same issue as follows:
First I created this measure:
COUNTROWS(ALLSELECTED('table'[variable]))
Then I used this measure as a filter on the table, in my case: measure is greater than or equal to 3.
This results in the table not showing any data if the number of rows selected is 3 or less.
As a warning, I created an info button with a tooltip that says that the table won't show any data if less than 3 persons are selected. This solution worked for me, but there might be other ways to deal with this.
Is there maybe a new solution to this problem?
My workaround would be to use R or Python custom visuals, which includes ifelse statements.
i.e.:
sample_large_enough <- if(nrow(dataset) > 10, 1, 0)
ifelse(sample_large_enough ==TRUE){
--execute R code:
1) data transformation
2) visualization--
}else{
--execute R code to display warning message "subset too low"--
}
Hi Chris,
I'm afraid there isn't such a function that can hide a visual for now. There is a workaround. We can add a measure to the visual and filter out the values "Minimum Data - Warning" in the Visual Level Filter.
Can you share a small sample, please? Please mask the data first. The data model structure is the critical part when creating such a measure.
Best Regards,
Dale
Hi Chris,
Do we have any solution for this now?
I have a same requirement to hide the complete visual if any record from it has <N value and I'm still not finding a way to hide a complete visual just with this condition.
Thanks in Advance.
Regards,
Prabha
Instead of using bookmarks, perhaps you could write a formula that basically says:
if(sum([count])<10, 'Too Few', [Value]
That would mask the individual cells, and you'd have to work on the "count" field to be an accurate representation of what shows up.
I was also wondering if there is a way to force a certain number of slicer selections so that you don't have peer groups of less than X number. In other words, that if only four selections were made in a slicer, then data wouldn't show but if five or more are made, then the table populates?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
248 | |
122 | |
110 | |
77 | |
70 |