Greeting Phrase - Sales Analytics Dashboard

[AnaCordeiro]

Hi every body! I need a help, because I don't know of is possible or madness.

In the company I work for, we have a Power BI that serves as a query for our sellers, where they can view their orders.

And we want the first dashboard to have a greeting, like "Hello, 'here will have the name of de user who is logged in to Power BI online'".

Is that possible? And how can I do it?

I have tried using the formulas USERNAME, USEROBJETID and USERPRINCIPALNAME, but just brings me the user's email or a code, I would like the name to appear.

[v-yilong-msft · Accepted solution]

Hi @AnaCordeiro ,

I find a topic and change it to satisfy your requirements: Solved: How to display Username with greetings when user ... - Microsoft Fabric Community

I create a table as you mentioned.

Then I create a calculated column and get what you want.

Greeting =
VAR user =
    USERNAME ()
VAR greeting1 = "Hello, 'here will"
VAR greeting2 = "is logged in to Power BI online'"
RETURN
    greeting1 & " " & user & " " & greeting2

Best Regards

Yilong Zhou

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

[Alex87]

You can use either USERPRINCIPALNAME or USERNAME to get the user's login name, you just need to either extract text before '@' delimiter for USERPRINCIPALNAME, or after the domain name '/' for USERNAME.

[lbendlin]

So you want to tell them what their own name is?