Forum Discussion

sanimesa's avatar
sanimesa
Icon for Post Prodigy rankPost Prodigy
8 years ago

Common dynamic text to every report

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! 

Need Help

7 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    8 years ago

    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's avatar
      sanimesa
      Icon for Post Prodigy rankPost Prodigy
      8 years ago

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

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper User
        8 years ago

        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. 

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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's avatar
      sanimesa
      Icon for Post Prodigy rankPost Prodigy
      8 years ago

      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's avatar
        v-yulgu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        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