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

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 is there any way to make report more pretty , hide columns base on slicer value ?