Forum Discussion

Sdaniels3152's avatar
Sdaniels3152
New Member
9 years ago

Rename column value for some users

I have a table with data from dealerships and one column has the name. Every dealership has an account. What I would like to do, is to hide the name of the other dealerships when one dealership logs...
Need Help
deldersveld's avatar
deldersveld
Resident Rockstar
9 years ago

With or without RLS, you can still create a measure that uses either USERNAME() or USERPRINCIPALNAME() to associate the dealer login with the correct column value.  If there's a table that contains records for both the dealer login and correct column value, you could use something along the lines of = LOOKUPVALUE('Table'[Column Value],'Table'[Dealer Login, USERPRINCIPALNAME())

Sdaniels3152's avatar
Sdaniels3152
New Member
9 years ago

Thank you, I did not know the function "username()". But what I need is to change the name in the table.

For example, if "Username()" returns "Dealership x", only "Dealership x" name should be shown, the other dealership names should be hidden or replaced with a code, image...

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Sdaniels3152,

    I don’t think that you can replace other dealerships’ names with a code, image when a specific dealership logs in his own account. However, you can hidden other dealerships’ names and their related data in this scenario, you can review the following blog about how to achieve this requirement by implementing dynamic Row Level Security.

    http://radacad.com/dynamic-row-level-security-with-power-bi-made-simple

    Thanks,
    Lydia Zhang