Forum Discussion
anonymise the data
Hi,
i have request to anonymise data in powerbi. client ask to add drop down to report to breake down report
for example :
if Id is selected , report shows customerid and other measures ,
if Name is selected , report shows customerid and other measures
i wrote dax., but seems Dax can not change deminsion base on measures
NewColumn = IF([selection]="id" , CONVERTCustomer[id], STRING) , Customer[name])
if dropdown changed,it doesnt work
data look likes:
| id | name | sale |
| 1 | c1 | 10 |
| 2 | c2 | 15 |
| 3 | c3 | 20 |
| 4 | c4 | 25 |
Anonymous
You may create a slicer table by just enter id and name in the column, and use it as slicer, and create 2 measure for id and name., the downside is you cannot hide the header of the other field. Please see my example pbix.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
9 Replies
Anonymous
You may create a slicer table by just enter id and name in the column, and use it as slicer, and create 2 measure for id and name., the downside is you cannot hide the header of the other field. Please see my example pbix.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.That is correct, you need to do the anonymization much earlier, either in Power Query or in the data source. Depending on your intended interaction choices you will have to duplicate your data (a lot).
Let's say you have six users, and for each of them you want to show how they compare to "the five other users without naming names" then you need to prepare six duplicates of your data. AND you need to apply RLS.
If you do all this in DAX then your data is not secure, and your users can easily de-anonymize it.
Enable "Personalize visual" preview function and teach your users how to use it. This empowers them to change the dimensions themselves.
Thanks for tip, but im not sure you got my question!
clinets need to have drop down filter on their report , two item is in drop down (user id , user name)
and base on what they select on drop down, report should show information ( becuase sometimes they have presentation and they need to do anonymise data)
if "user id" is selectd , chart show userid and total hours for each useridthen Client can change it to "user name" and chart show user name and total hours
They don't need to have a dropdown. You think that is needed, but it is only one of many possible designs. using "Personalize Visual" is an alternative implementation to achieve the same goal.
Anonymousone of the ways to achieve what you need will be through a use of disconnectd table attached here
https://drive.google.com/file/d/1sDTpiywgIeUa53zcrol2S4t_fcZqrFGN/view?usp=sharing
