Forum Discussion
Rai_BI
2 years agoHelper IV
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...
- 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.
v-zhangti
2 years agoCommunity Support
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.
- Rai_BI2 years agoHelper IV
Thank you!