Is there a method to prevent PowerBI visual displaying results when record count is under 5?

[Anonymous]

I have a real world problem that has me stumped. I have a powerBI report that is list of employee survey answers. Before I share it with the firm, I need to make sure that no individual can be identified by simply playing with the slicers ("Marketing director in California hates management... we only have one marketing director in California).

Is there a function or a workaround I can use to either prevent the visuals from updating when the count of records is below 5 or to display a message "count of records too low, broaden your selection.

[parry2k]

@Anonymous oh! Thanks for your comments. Glad it worked out. Cheers!!

[parry2k · Accepted solution]

@Anonymous try this on your end: add a new measure:

Total Count = COUNTROWS ( Table )

on visual, add a visual level filter with the above measure and select where greater than 5, if you slice the data and the number of records is less than 5, your visual will go blank. We can figure out the message part later.

[Anonymous]

You are my hero today.

[parry2k]

@Anonymous ok, so what is our expectation from that excel file? What I'm doing with it? If you provide a bit more details, it will help.

[Anonymous]

The excel file has a list of survey responses. What I am trying to prevent is someone using the slicer to narrow down the results to less than 5 and be able to indentify the individual who provided the response. 

My desired outcome is that if the slicer selections result in a visualization output with less than 5 records the visualization is hidden, an alert is displayed ("please expand your selection") or any other method that would prevent the viewer from seeing result set of bellow 5 records. 

[parry2k]

@Anonymous can you share sample data and expected output, you can surely create a count measure and then put a visual level filter on this measure and say > 5 but without looking at data model it is hard to tell what would be the measure.

[Anonymous]

Yes, thank you. Sample recordset (15 records) I uploaded to dropbox as an excel file:

https://www.dropbox.com/scl/fi/zv98pk78rrjbs2qrmdkco/sample.xlsx?dl=0&rlkey=xz5jtky2ppqc89nq7zx150gv...

And this is how my slicer/viisual looks: https://imgur.com/a/rAOxtCh

Any help is greatly appreciated.