Anonymizing data ?

[Arkhos94]

I'm working on a set of chart to manage a group of car dealers

The idea is to show a serie of bar and bullet chart so each dealer can know how well they performed compared to other

Problem : dealer cannot be allowed to see any data or name but their own.

For example, one of the bar chart shows marketshares, ordered by the highest to the lowest.

Each dealer should be able to see its own rank and performance but should not know who is any of the other bar.

Does someone know if it's possible and how ?

[Anonymous · Accepted solution]

Hi @Arkhos94 ,

It seems that you want to restrict each dealer to only view their own data, but also show their ranking and percentage among all dealers and hide the information of other dealers. Please check the following blog to see if you can achieve your needs by using RLS and creating a Copy of the Table with the Confidential Data.

Row-level security (RLS) with Power BI

Secure the Sensitive Data in Power BI; Data Masking better with Row-Level Security

Best Regards

[amitchandak]

@Arkhos94 , create another summarized table without dealer and join it with common dimensions other than the dealer and then secure dealer dimension using RLS and created market sharing suing the new table

[Arkhos94]

thanks for your help

I'm not sure I understand everything through

Creating a summarized table I understand. But I don't understand how I can do it without dealer. Can you explain more ?