How to Mask Sensitive Data in Dashboard Visuals
When designing dashboards, it is important to protect sensitive information such as phone numbers, ID values, or financial data. Bold BI allows you to mask this type of sensitive information using expression support.
Please follow the steps below to achieve this.
Example: Mask a Phone Number
If you want to show only the last two digits of a phone number, use this expression:
CONCAT('(***) *** ** ', RIGHT([Phone], 2))
This expression works across SQL Server, PostgreSQL, and MySQL databases.
What this expression does,
'(***) *** ** ’ → Provides the masked pattern that hides the first part of the phone number
RIGHT([Phone], 2) → Extracts only the last two digits from the phone number
CONCAT(…) → Combines the masked pattern with the last two digits
So, if the phone number is 98765432, the dashboard will show:
(*) *** ** 32
This expression ensures that the majority of the phone number is masked, displaying only the last two digits. You can adjust this logic as needed to suit your specific masking requirements.
Additional References
