Skip to main content

Power BI

New

Refering to "Objects" of/in PowerBI-File by DAX e.g. Page Names

Vote (2) Share
Thomas Reick's profile image

Thomas Reick on 20 Aug 2022 08:49:01

Hello there,


In VBA (MS-Access) you can refer to contols in a form by keyword "Me"..E.g. Me.MyControlName.MyCaption="Hello World" displays "Hello World" as the controls caption, Me represents the actual (Form-) Object.


Why not use this approach inside PBI to handle Captions for PBI-Content coming as a return value for Measures?


My idea is to refer in DAX to e.g. PageNames (or internal Page-Enumeration) of reports to handle as a parameter for DAX.


By this the actual page-object is used as input parameter for looking-up the returning expression for DAX-Measures (eg for Headline-Caption displayed in a multi row card.to show as the Page title).


Benefit: Editing the DAX-Code-Script in one spot, individual editing on report pages avoided.


Please think on this,


Appreciating your comments.


thx


Thomas