Forum Discussion

Rai_BI's avatar
Rai_BI
Helper IV
2 years ago
Solved

Get RLS applied and show in title

Guys, I have a reasoning problem here, I created a dashboard in Power BI with some sales information. In this report I applied RLS security so that users only see information about the customers the...
  • v-zhangti's avatar
    2 years ago

    Hi, Rai_BI 

     

    You can try the following methods.

    Dynamic Salesperson Title = 
    VAR CurrentUser = USERNAME()
    VAR SalespersonName = LOOKUPVALUE(UsernameTable[SalespersonName], UsernameTable[Username], CurrentUser)
    RETURN
    IF(
        ISBLANK(SalespersonName),
        "No salesperson found",
        SalespersonName
    )

    If this does not solve your problem, please provide more details.

     

    Best Regards,

    Community Support Team _Charlotte

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