Title Dynamic Using Buttons

[Nfuentes86]

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

[v-pnaroju-msft]

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.

[v-pnaroju-msft]

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 · Accepted solution]

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]

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]

I have not been able to figure out a solution. 

[v-pnaroju-msft]

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.

[adudani]

hi @Nfuentes86 ,

reference : https://www.youtube.com/watch?v=TYLKDPcvgK8&pp=ygUYZHluYW1pYyBoZWFkZXJzIHBvd2VyIGJp 

try using SELECTEDVALUE function - DAX | Microsoft Learn.

else potentially field parameters : https://www.youtube.com/watch?v=BLNqU2jJ7u0&pp=ygUgZmllbGQgcGFyYW1ldGVycyBkeW5hbWljIGhlYWRlcnM%3D 

if this doesn't resolve the issue, kindly provide a sample input masking sensitive data

[Nfuentes86]

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.