Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 ...
Data Protection
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 userid

then Client can change it to "user name" and chart show user name and total hours