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