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