Forum Discussion
Helper IIConfidentiality Threshold in a Report
Hello Folks,
We have a requirement in dashboard, we want to implement confidentiality threshold across all tabs of power BI report where if the user makes a selection with fewer than 5 employees(if he is getting data fewer than 5), the data will not be shown. e.g. I have HR dashboard where I am checking number of new joinees(hires) in a tab. There are 8 hires in Jan 2021 but there are only 4 in Feb 2021. In this case, I should see data for Jan but no data for Feb.
Please let me know if this is possible.
Hey lokeshb31 ,
that should be possible. Be aware that in the measures you have to do a COUNTROWS and if that is less than 5, then simply return BLANK() and otherwise the measure.
I wouldn't just change the time frame as user are getting pretty confused when they select February and suddenly the data is from January. From my experience it's better then to show nothing.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
1 Reply
- selimovd
Most Valuable Professional
Hey lokeshb31 ,
that should be possible. Be aware that in the measures you have to do a COUNTROWS and if that is less than 5, then simply return BLANK() and otherwise the measure.
I wouldn't just change the time frame as user are getting pretty confused when they select February and suddenly the data is from January. From my experience it's better then to show nothing.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic