Making customer names Anonymous

[Anonymous]

I've had a request to share my data outside of my company, no problem, I know how to do that.  But, I can't share my customer names in the dashboards.  Is there a way for me to redact or just anonymize the names easily?  Even a switch that would allow me to change the Name to Industry could work - I just cannot show the company names.

[Anonymous · Accepted solution]

Hi  @Anonymous

I think this solution will work for you.

https://community.powerbi.com/t5/Desktop/How-to-anonymize-mask-part-of-string/td-p/266566

Thanks

Raj

[Anonymous]

Interesting follow up request.  Is there a way to toggle what is displayed in a report for a table column?  ie between two fields.  I'm looking to build a toggle to swap out the AccountName with MaskedAccountName.

[Anonymous]

Hi Raj,

I was able to create the index column and then merge my Industry with that Index.  That works very well!