Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Mask Data Based on Dynamic Slicer Selection

Hello,

 

I have some data in a 'raw_data' table that has Customer information:

NameMonthIncidence
Bill1.98
Bill2.96
Bob1.88
Bob2.81
Brian1.91
Brian2.82

 

And I have another table that creates an Alias:

NameAlias
BillCustomer 1
BobCustomer 2
BrianCustomer 3

 

My goal is to build a dashboard that has a slicer in which I am able to select a name. So, if I select 'Bob' in the slicer, then the dashboard will mask all other names to the 'Alias'[Alias] value so Bill will show up as 'Customer 2' and Brian as 'Customer 3'.

 

I've seen articles that show me how to anonymize data. But I only want to partially anonymize because I want to see the name I select, but the alias for the other names. And I don't think I want row level security because I want to see all the data, but just mask it based on which slicer I select.

 

Any help would be greatly appreciated.

Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi Anonymous ,

     

    Please check if this is what you want:

     

    1. Add an Index column into "Customer" table to show all rows in the table visual.

     

    2. Don't create active relationships between "Cusomer" and "Alias" table.

     

    3. Create a measure.

    Measure =
IF (
    MAX ( Customer[Name] ) = SELECTEDVALUE ( Alias[Name] ),
    SELECTEDVALUE ( Alias[Name] ),
    LOOKUPVALUE ( Alias[Alias], Alias[Name], MAX ( Customer[Name] ) )
)

     

    4. Result:

     

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • Icey's avatar
    Icey
    Community Support
    5 years ago

    Hi Anonymous ,

     

    Please check if this is what you want:

     

    1. Add an Index column into "Customer" table to show all rows in the table visual.

     

    2. Don't create active relationships between "Cusomer" and "Alias" table.

     

    3. Create a measure.

    Measure =
IF (
    MAX ( Customer[Name] ) = SELECTEDVALUE ( Alias[Name] ),
    SELECTEDVALUE ( Alias[Name] ),
    LOOKUPVALUE ( Alias[Alias], Alias[Name], MAX ( Customer[Name] ) )
)

     

    4. Result:

     

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.