How to hide Phone numbers, but the last 4 digits

[RBPI]

Dear Memebers, 

A quick question came-up and it's about data masking. I'm working on a project which requires to replace the 6 digits of all customers phone numbers but not the last 4. However, the phone number should be searchable when someone types the whole number. It's also required that if the report is printed, phone numbers should be masked and only the last 4 digits should be visible. 

Ex. A phone number like 777-777-7777 should be XXX-XXX-7777. But, when someone is searching and using the full number on the PowerBi report- 777-777-7777 it should result to a success and show the rest of the coulmns in the report. 

Thanks for you help here 🙂 

[SamInogic · Accepted solution]

Hi @RBPI ,

You can try to create a new custom column with below DAX expression,

Masked Phone Number = SUBSTITUTE(Phones[Phone Number], LEFT(Phones[Phone Number], LEN(Phones[Phone Number])-4),"XXX-XXX")

Please refer to the below screenshot for the same,

Thanks!

Inogic Professional Services Division

Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

Drop an email at crm@inogic.com

Services:  http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

[RBPI]

@samlnogi - Thank you very much for your input here. The function you recommended worked, but I also figured it out with DAX Replace Function. I'll accept your recommandation as a solution to this. Thanks again!