How to hide some informations in table depending on a role

[alexpohl]

I have the following problem.

In my market we have different dealers and the manager of the market can see the ranking of all dealers.
The dashboard has RLS and if the dealer will see the dashboard, I will let him see his ranking, but not the names of the
other dealers.

The Example:

the complete market

Selection of Garage number 250 (This is what it should look like) with the role of this dealer 250

I hope you can help me. I doesn`t found any solution about this problem.

[alexpohl]

unfortunaly, It doesn`t help me. How is it possible to hide this values based on a role? I don`t understand it.😞
if i show it with the roles, i can see only the value for this garage, but I will show all informations about all garages, but the name of the other garages must be hidden.

[miTutorials]

The below tutorial should help.

Create Row Level Security (RLS) to restrict access in PowerBI | MiTutorials - YouTube