cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

passing a selected bookmark name to a text field

I have a report that uses 17 different slicers to select the desired records from two tables for various visuals.  I have 48 programs, each with bookmarked selections from one or more slicers, along with another bookmark that clears all slicers.  I have 4 different report pages.  I would like to be able to populate a text box with the name of the bookmark selected and have it update with each selection to show the last selection made.  All of the samples I've found for dynamic labeling seem to be conditioned on passing the selected value from a column, but in my case there is no such column available as each bookmark may utilize slicers on any variety of columns.

 

If you select View from the Bookmarks pane it will display the name of the bookmark at the bottom of the page, similar to: Bookmark 2 of 48, All Cleared.  However, with the bookmark name showing at the bottom of the page you can't move to another page without first exiting from the View option in the bookmarks pane.  The display of the information when choosing the View option strongly suggests that same value that displayed information on the bottom of the page should be available for passing to a text box on the different report pages.

4 REPLIES 4
KilleenJeffrey
Frequent Visitor

How I solved a simular issue...

First I wrote a query to build a table that is a directory of the bookmarks with descriptions...

let
Source = Table.FromRows(
{
{"VCM", "VCM No Filters", "Catalog Items not Filtered"},

{"VCM", "VCM Business Duplicates", "Business Sigificate Duplicate Catalog IDs"},
{"VCM", "VCM Data Duplicates", "All Duplicate Catalog IDs"},
{"VCM", "Used cmP & cmC Active", "Catalog ID Defined both in cmP & cmC"},
{"VCM", "cmP Missing From sm", "A cmP Catalog ID missing from sm"},
{"VCM", "cmC Missing From sm", "A cmC Catalog ID missing from sm"},
{"VCM", "Mastered Both cmP & cmC Active", "Active Catalog ID Defined both in cmP & cmC"},

{"VCM", "VCM OEM Multi", "Catalog Items with Different OEMs Between Catalogs (Apps)"},
{"VCM", "VCM OEM Miss", "Catalog Items with No OEMs Defined In Any Catalog (App)"},
{"VCM", "VCM Class Multi", "Catalog Items with Different Classes Between Catalogs (Apps)"},
{"VCM", "VCM Class Miss", "Catalog Items with No Classes Defined In Any Catalog (App)"},
{"VCM", "VCM Catagory Multi", "Catalog Items with Different Catagories Between Catalogs (Apps)"},
{"VCM", "VCM Catagory Miss", "Catalog Items with No Catagories Defined In Any Catalog (App)"},
{"VCM", "VCM Family Multi", "Catalog Items with Different Families Between Catalogs (Apps)"},
{"VCM", "VCM Family Miss", "Catalog Items with No Families Defined In Any Catalog (App)"},
{"VCM", "VCM CRMLine Multi", "Catalog Items with Different CRMLines Between Catalogs (Apps)"},
{"VCM", "VCM CRMLine Miss", "Catalog Items with No CRMLines Defined In Any Catalog (App)"},
{"VCM", "VCM Group Multi", "Catalog Items with Different Groups Between Catalogs (Apps)"},
{"VCM", "VCM Group Miss", "Catalog Items with No Groups Defined In Any Catalog (App)"}
},
type table [PageName = text, BookmarkName= text, BookmarkDescription= text]
)
in
Source

Next I added a Table visual to the page...

Table Visual.jpg

Finally with each bookmark I set the appropriate filter for this Visual and updated the bookmark

Filters.jpg

The end result being the each bookmark selection changes the text at the top right......

Page.jpg

@KilleenJeffrey 

This is a great tip and I just put it to use in my report.

 

Thank you! 

Anonymous
Not applicable

Thanks for the information.  This looks like something I could use.  May be some time before I can work on modifying the project for which I wanted this information, but am looking forward to trying it when I can.  Thanks for the example screenshots, they are really helpful in understanding!

v-xicai
Community Support
Community Support

Hi @Anonymous ,

 

It is not supported to implement your demand "populate a text box with the name of the bookmark selected and have it update with each selection to show the last selection made" in Power BI Desktop currently .There is an idea about this issue, please vote it up, https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31789180-link-comments-to-bookmark-enable-a-text-box-displ , to improve the Power BI Desktop.

 

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

We also submitted this feedback to the product group internally, so that the product group can pay attention to this problem and speed up the issue repairing.

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.