Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi,
I have a question regarding the implementation of certain privacy guarantees in a report that I am creating. I am mostly working with self-reported data, and I am using slicers (like gender, age, seniority, etc.) to enable my users to do meaningful analyses on the data. However, to protect the privacy of the respondents, I would like to prevent the users of my report to use the slicers in such a way that they can create groups that are smaller than 7 respondents (because in that case, there might be a risk of identifying these respondents). For example; if there are only 6 male respondents under the age of 25 with a seniority of over 3 years, I would like to prevent the user to actually see the charts when he tries to create this combination with the slicer, and provide him instead with an alert asking him to adjust his selection. I have been googling and looking into the documentation that I found, but I have not really found much information on how to do this. Does anyone have any leads on how I could do this? I know that it should be possible because I have seen it once before in an existing report, I have tried to contact the creator of this report but unfortunately cannot reach him...
Thanks in advance!
Hanne
Solved! Go to Solution.
Hi @Anonymous ,
I got a workaround to your problem. I have created currently an example for one chart on 'EAP - Optie 1' tab. You can use the same for other charts as well. The bottom right LINE chart will show the difference when count is < 7.
Please use the following link to download the updated .pbix file:
I have created a measure "IS Valid Group" in table "OrigineleData".
In order for this measure to work around all your visuals coming from different tables, try checking your relationships.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Hi @Pragati11
Thank you so much for this solution! To make sure it works on all our visuals, we will indeed have to check the relationships, but it does work on all visuals that are directly based on 'OrigineleData'
Kind regards,
Hanne
Hi @Anonymous ,
Thanks for sharing .pbix file. This report contains a lot of tabs.
Which Tab refers to the query that you have highlighted?
Thanks,
Pragati
Hi @Anonymous ,
Actually the language on the dashboard confuses me.
You will have to give some description around your data. What is the GROUP, RESPONDENTS you are refrerring to in your question.
It's hard to understand your requirement.
Thanks,
Pragati
Hi @Pragati11
You are right, if you have a different native language this is probably hard to understand, my apologies.
Perhaps for the sake of this exercise, let's take tab 'EAP - Optie 1'
On the left of this tab, you see the different slicers: 'departement', 'gender' and 'leeftijd'(=age). You also see a card 'aantal deelnemers' which displays the number of survey participants that are included in the graphs. If this number becomes lower than 7, I would like the charts that are displayed on the center of this page (the 4 bar charts and the line chart) to become invisible or unreadable, and show an alert instead, something like 'the group you created is smaller than 7 respondents. Please adjust your filters'.
For example, when you select '3' under department and 'male' under gender, you can see that 'Aantal deelnemers' is only 5. This is one of the situations in which I would like to hide the charts somehow.
Hanne
Hi @Anonymous ,
I got a workaround to your problem. I have created currently an example for one chart on 'EAP - Optie 1' tab. You can use the same for other charts as well. The bottom right LINE chart will show the difference when count is < 7.
Please use the following link to download the updated .pbix file:
I have created a measure "IS Valid Group" in table "OrigineleData".
In order for this measure to work around all your visuals coming from different tables, try checking your relationships.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Hi @Pragati11
Thank you so much for this solution! To make sure it works on all our visuals, we will indeed have to check the relationships, but it does work on all visuals that are directly based on 'OrigineleData'
Kind regards,
Hanne
Hi @Anonymous ,
That's really good to know.
I will appreciate if you can mark my post as a solution to your query. 🙂
Thanks,
Pragati
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
93 | |
85 | |
84 | |
73 | |
49 |
User | Count |
---|---|
142 | |
133 | |
110 | |
68 | |
55 |