Dynamic Tittle not Showing on Power BI

DAX DAX Calculations
1

Hi,

I did create a dynamic title on my home page which just read " Welcome Austine …"
However, when i published to Power BI, i get a different result.

Any solution on how to sort this…

This is how it was before publishing

image

and after publishing

image
image745×117 6.11 KB

and the calculations i used

Greetings = SUBSTITUTE(CONCATENATE(CONCATENATE(“Welcome”," “),UPPER(RIGHT([User],LEN([User])-16))),”."," ")

And finally

Final Greetings = CONCATENATE(CONCATENATE([Greetings]," "),“To”)

The Rest are just static text box message

2

username() will return a user in the format of DOMAIN\User
and userprincipalname() will return a user in the format of user@domain.com.

1 Like
3

@alora101,

Here’s a possible reason, based on info in the Microsoft online DAX function documentation on SUBSTITUTE:

This DAX function may return different results when used in a model that is deployed and then queried in DirectQuery mode. For more information about semantic differences in DirectQuery mode, see https://go.microsoft.com/fwlink/?LinkId=219171.

As a potential fix, try using the REPLACE function instead of SUBSTITUTE and see if that solves the problem.

  • Brian
4

Thanks very much.

I love this place. Best site ever compare to Expert exchange

5

Thanks Brain.

Much appreciated. You guys rock