Customize Data labels format
Data Masking for Sensitive values
If we have to work with sensitive data in our Power BI reports, the following tip could be suitable to hide the values of some data points.
We can change the format of data values and choose how are displayed.
👇In this example I have hidden the salaries that are below 100K
The trick is to create two DAX measures, one with the salaries we want to display with normal data labels and the second for the salaries we would like to hide and format them. (For this example I am displaying the data labels format of the second mesure as follows: "salary<100k 🔓🔓" )
Avg salary >100K = IF([Avg Salary]>100000,[Avg Salary])
Avg salary <100K = IF([Avg Salary]=<100000,100000)