Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.