How to display Username with greetings when user log in?

[Charu]

Hi Everyone,

Please let me know whether my requirement is possible in power bi service login using RLS(row level Security)

example: When I log in to the report the left side I would like to display My name with greetings.

Based on login time Greeting should change like Good morning,Good Afternoon,Good Evening

[Greg_Deckler · Accepted solution]

Greeting1 = 
VAR user = USERNAME()
VAR display = LOOKUPVALUE(Table1[User],Table1[Email],user)
VAR hour = HOUR(NOW())
VAR minute = MINUTE(NOW())
VAR prefix = SWITCH(
                    TRUE(),
                    hour<12,"Good morning ",
                    hour>=12 && hour<17,"Good afternoon ",
                    "Good evening "
             )
RETURN CONCATENATE(prefix,display)

[Greg_Deckler]

How about a measure in a card visual like this:

Greeting = 
VAR user = USERNAME()
VAR hour = HOUR(NOW())
VAR minute = MINUTE(NOW())
VAR prefix = SWITCH(
                    TRUE(),
                    hour<12,"Good morning ",
                    hour<17,"Good afternoon ",
                    "Good evening "
             )
RETURN CONCATENATE(prefix,user)

[Charu]

Wow! Great @Greg_Deckler.Thank you.

Username() returning sara@xyz.com instead I need the name only .so I'm maintaining one column to store the list of username in each table. 

suppose If I have 3tables connected to the report and each table I will be having UsernameList and Email list

how could I pass username list column in the parameter

var User =UsernameList

UsernameList is the filed name in my table

 thanks in advance

[Greg_Deckler · Accepted solution]

Greeting1 = 
VAR user = USERNAME()
VAR display = LOOKUPVALUE(Table1[User],Table1[Email],user)
VAR hour = HOUR(NOW())
VAR minute = MINUTE(NOW())
VAR prefix = SWITCH(
                    TRUE(),
                    hour<12,"Good morning ",
                    hour>=12 && hour<17,"Good afternoon ",
                    "Good evening "
             )
RETURN CONCATENATE(prefix,display)

[Charu]

Thanks a lot, it's working fine in desktop but once i publish to service the time is wrongly showing please help me where I'm doing mistake

I published on 7:39pm that is 19:39 instead it's showing 14:06

[Greg_Deckler]

Have a look at this blog:

http://radacad.com/solving-dax-time-zone-issue-in-power-bi

But, short story is the easiest way will be to just put an offset into your hour calculation to account for your timezone difference between where you are an where Power BI is hosted.

[shoeb1359]

It's not working with Userprincipal for other user.Their name is mapped with correct email id

Greeting =

VAR user = USERPRINCIPALNAME()

VAR display = LOOKUPVALUE(Detail[Name],Detail[Email Id],user)

VAR hour = HOUR(NOW())

VAR minute = MINUTE(NOW())

VAR prefix = SWITCH(

TRUE(),

hour<12,"Good morning ",

hour>=12 && hour<17,"Good afternoon ",

"Good evening "

)

RETURN CONCATENATE(prefix/*"Welcome. "*/,display)

[Charu]

Hi @shoeb1359

If your Detail[Name] lookup values return the username then try using the USERNAME() function instead of USERPRINCIPALNAME()

[Charu · Accepted solution]

Hi

below is how I achieved the Timezone difference, for your reference