Survey: Prevent visuals from displaying data for less than 5 responses

[AJV]

Hello:

I'm putting together a report for a survey. To protect the confidentiality of respondents, I need to prevent a filter or combination of filters from displaying data where there were less than 5 responses. The visual can display an asterisc *,  an error or go blank if there's less than 5 - it doesn't matter.

Is there a way to configure the report, filters or the visuals to accomodate this?

Thanks!

[AJV]

So, row level security won't work with this use case.

@AllisonKennedy Wondering if you have any thoughts on how to adapt the "Responses to Show" measure to capture more than one filter selection that adds up to 5 or more?

[amitchandak]

@AJV , See if masking can help

https://radacad.com/secure-the-sensitive-data-in-power-bi-data-masking-better-with-row-level-securit...

[AJV]

Thanks!

Row level security looks like it would be a great idea, especially in that it would allow me to continue to see what I would not want the client to be able to see.

However, I'm having trouble with the DAX expression/filter. Newbie here...I've tried a few combinations of @AllisonKennedy 's suggestions which worked as filters, but not in this case.

Any ideas?

[AllisonKennedy]

@AJV  You could use explicit measures for all the visualizations and put an IF in front of them. You'll need to create a measure for total responses: 

Total Responses = COUNTROWS(ResponseTable)

Then all other measures will need: 

Responses to Show = IF([Total Responses] < 5, BLANK(), [Total Responses]) 

Or whatever calculation you want to do.

[AJV]

Thank you for this!

I've  created TOTAL RESPONSES and RESPONSES TO SHOW. Adding TOTAL RESPONSES to the filters for the visual works when I select another filter that shows less than 5 responses. The visual disappears. Perfect!

However, if I select a combination of locations with fewer than 5 responses, but together add up to five or more responses, the visual does not reappear with that calculation.

Any ideas?

(Newbie here...appreciate your help, tremendously...)

[AllisonKennedy]

What is in the visual? Is it sliced by anything that is causing the total responses to be less than 5 in each category maybe? If you can provide just a few more details about what you're doing we can try to help more.

[AJV]

Hi Allison - thanks. 

Each visual is relatively simple. Each displays one survey question, and its breakdown of responses in a pie chart from agree to disagree. Otherwise, there are two card visuals which are simply average scores from one column on a table. 

the data is also simple - one table.