dynamically rename page names in power bi desktop

[Krishnan_47]

Hi All,

Can I dynamically rename a sheet/page name in power bi desktop? Currently it is Page1 and Page 2 as shown in below screenshot. For different users the page name should vary dynamically. For example, SG users should see page names as SG1 and SG2.

[danextian · Accepted solution]

Hi @Krishnan_47 ,

I don't think that is currently possible. Alterntively, you add a single row card as the page title, say, on the upper left of the page. You'll be needing a table of userprincipalname/logged in email (name@domain.com) and their corresponding location - eg, SG1 for user1@domain.com. Note: USERPRINCIPALNAME will return a value only in Power BI service.

sample output

sample table

sample measure

Location Title =
CALCULATE (
    MAX ( 'Table'[location] ),
    FILTER ( 'Table', 'Table'[userprincipalname] = USERPRINCIPALNAME () )
)