Forum Discussion

Nfuentes86's avatar
Nfuentes86
Helper I
1 year ago
Solved

Title Dynamic Using Buttons

Hi guys, I currently have a title Dynamic on my TITLE but now i want the title to also reflect the buttons name? Example "Weekly Progress hours by PF" please help

  • Nfuentes86's avatar
    Nfuentes86
    1 year ago

    Solution I figured out: 

    1. Create two copies of the title text box. One will say Hours one will say PF.
    2. Open the Selection pane. Rename the title text boxes to "PF title" & "Hours title"
    3. Create 2 bookmarks. One will be PF, the other hour
    4. Hide "PF title". Hide PF chart visual
    5. Update "Hours bookmark"
    6. Unhide "PF title. Unhide PF chart visual.
    7. Hide "Hours title". Hide hours chart visual
    8. Update "PF bookmark"
    9. Link the hours button to the Hours bookmark
    10. Link the PF button to the PF bookmark
    11. Deselect "data" from bookmark options

8 Replies

    • Nfuentes86's avatar
      Nfuentes86
      Helper I

      I am already using title dynamic for the title based on disicpline name selection but now I want to ADD the buttons name selection. The buttons are bookmarks. 

       

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Community Support

    Thank you adudani  for your response.

    Hi Nfuentes86,

    Thank you for the follow-up.

    As per my understanding of the query, you are already using a dynamic title based on the selected discipline, and now you would like to include the selected button, i.e., the bookmark name, in the title — for example: Weekly Progress Hours by PF.

    Since Power BI buttons do not retain state directly, a suitable approach is to combine them with a hidden slicer and synchronize it using bookmarks.

    Kindly find below the steps which may help resolve the issue:

    1. Create a supporting table that lists your bookmark or button names (e.g., Weekly View, Monthly View, etc.).

    2. Use this table in a hidden slicer on your report page.

    3. Update each bookmark to not only switch the view but also set the slicer selection.

    4. Create a dynamic title measure that combines the selected discipline and the selected bookmark name.

    5. Apply this measure as a conditional title for your visual using the field value formatting option.

    If you find our response helpful, kindly mark it as the accepted solution and consider giving it a kudos. This will assist other community members who may be facing similar queries.

    Thank you.

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Community Support

    Hi Nfuentes86,

    We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

    If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

    Thank you.

    • Nfuentes86's avatar
      Nfuentes86
      Helper I

      I have not been able to figure out a solution. 

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Community Support

    Hi Nfuentes86,

    Thank you for the update.

    Please find below the approach to resolve this issue:

    1. Create a small table in Power BI (for example, named BookmarkOptions) with a single column (for instance, BookmarkName) containing HRS and PF as its rows. This can be accomplished by using the Enter Data option in the Home tab.
    2. Place this table in a slicer on your report page, and then hide it by adjusting its size or using the Hide option in the Format pane. This slicer will track the bookmark selection.
    3. In the Bookmarks Pane, create two bookmarks (for example, HRS_Bookmark and PF_Bookmark). For each bookmark, set the view state and use the Update button to include the slicer selection (set to HRS for the HRS bookmark and PF for the PF bookmark). Link these bookmarks to your HRS and PF buttons, respectively.
    4. Modify your existing dynamic title measure to incorporate the selected bookmark name from the slicer. You can use a simple DAX expression to concatenate the discipline and bookmark names.
    5. Set this measure as the title of your visual or page using the Title formatting option in the Visualizations pane.

    If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.

    Thank you.

    • Nfuentes86's avatar
      Nfuentes86
      Helper I

      Solution I figured out: 

      1. Create two copies of the title text box. One will say Hours one will say PF.
      2. Open the Selection pane. Rename the title text boxes to "PF title" & "Hours title"
      3. Create 2 bookmarks. One will be PF, the other hour
      4. Hide "PF title". Hide PF chart visual
      5. Update "Hours bookmark"
      6. Unhide "PF title. Unhide PF chart visual.
      7. Hide "Hours title". Hide hours chart visual
      8. Update "PF bookmark"
      9. Link the hours button to the Hours bookmark
      10. Link the PF button to the PF bookmark
      11. Deselect "data" from bookmark options

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Community Support

    Hi Nfuentes86,

    We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

    If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

    Thank you.