March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
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...
Finally with each bookmark I set the appropriate filter for this Visual and updated the bookmark
The end result being the each bookmark selection changes the text at the top right......
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!
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
124 | |
87 | |
85 | |
70 | |
51 |
User | Count |
---|---|
205 | |
153 | |
97 | |
79 | |
69 |