Custom data details per user and aggregation sharing

Hi  
Two ways I think you might be able to do this.One would be create a measure for that column and say something like:

People names =
IF (
    SELECTEDVALUE ( employee[EmployeeId] ) --check row id
        IN CALCULATETABLE (
            VALUES ( employee[employeeId] ), --create a list of ids
            employee[managerEmail] = USERPRINCIPALNAME () --filter to manager email of report viewer email
        ),
    SELECTEDVALUE ( employee[EmployeeName] ), --show full name
    LEFT ( SELECTEDVALUE ( employee[EmployeeName] ), 1 )
        & REPT ( "*", LEN ( SELECTEDVALUE ( employee[EmployeeName] ) ) - 1 ) --show obscured name
)

So it checks if person viewing the report is the manager and if they are shows the name otherwise first letter plus *.

Or you could have two columns in the data Employee[EmployeeName] and Employee[EmployeeNameHidden] which would probably be better performance wise. You swap which column is showing using a FieldParameter based on the UserEmail.

Anonymous