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 ...
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.
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.