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.
Anonymous
Without big transformation of your current model, the above method is best workaround I can think of. And it is not possible to show/hide fields or the headers with slicer/filter.
Best Regards
Paul Zheng _ Community Support Team