Forum Discussion
anonymise the data
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.
That is correct, you need to do the anonymization much earlier, either in Power Query or in the data source. Depending on your intended interaction choices you will have to duplicate your data (a lot).
Let's say you have six users, and for each of them you want to show how they compare to "the five other users without naming names" then you need to prepare six duplicates of your data. AND you need to apply RLS.
If you do all this in DAX then your data is not secure, and your users can easily de-anonymize it.
alreay i have both column ID , Name
how can i change deminesion in powerbi chart!
when client change drop down, deminsion would change from ID to name or ... ?
Enable "Personalize visual" preview function and teach your users how to use it. This empowers them to change the dimensions themselves.