Common dynamic text to every report

[sanimesa]

We have a requirement where we have to add a line of text with meta information on each tab of each report. Is there a way to accomplish this without having to edit every report?

Additionally, this dynamic text will vary for each report. We are thinking of creating a table in out DB with the varying info for each report. However, how do we associate each row of report to its dynamic content? Ergo, are there DAX functions such as current report name etc. that fetches meta information about the current report? 

To elaborate, let's assume I have 3 reports.

DB Table:

Report Name             Dynamic information

Report 1                     Dyn Info for report 1

Report 2                     Dyn Info for report 2

Report 3                     Dyn Info for report 3

Each report will get this table and create a measure that pulls the appropriate dynamic info for display. 

Any pointers will be helpful! 

[v-yulgu-msft]

Hi @sanimesa,

There is no way to dynamically add text per report page.

What do you mean "add a line of text with meta information on each tab of each report"? If you want to show the meta information at the bottom tab on each report, you have to rename the report page one by one manually.

If you would display text message on report view with a visual, you could add the field [Report Name] to page level filter, and choose the specific name for each page.

Regards,

Yuliana Gu

[sanimesa]

@v-yulgu-msft Sorry, perhaps my comments were confusing. I do not want to change the names of the tabs. I want a text placed into each report as shown in the image.  The text will be different for each report (for the entire report, the same value displays on each page of the report). 

[v-yulgu-msft]

Hi @sanimesa,

That case, you can refer to the second scenario mentioned in my original post.

As the text values typed into Text box is always static, cannot be set to dynamical. You can use a Multi-Row card visual to display messages. Add the field [Report Name] to page level filter, and choose the specific name for each page.

Regards,

Yuliana Gu

[sanimesa]

@v-yulgu-msft I am surprised that on a script I can not detect the name or some sort of indentification of the report where the script  is running. Every programming environment I have worked on provides a feature where a script knows where it is running. It would be really helpful if Power BI added some meta information to reports accessible to DAX etc. 

[parry2k]

@sanimesadon't think there is any dax function which return report metadata. I'm afraid that you have to manually add it to each page.

[sanimesa]

@parry2k How about Power query? Does that have access to any meta information? The DAX username() function made me hopeful for a bit. 

[parry2k]

@sanimesaunfortunately not. I know username() makes you think that there might be opportunity to grab other metadata but I don't think there is anything.