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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

heading based on bookmark selected - is it possible

Hi,

I am trying to read the value in bookmark (something like selectedvalue or isFiltered) and based on that - change the Heading etc.

is it possible? is there a workaround ? 

Thanks 

 

 @MorrisBI @amitchandak 

2 ACCEPTED SOLUTIONS
MorrisBI
Regular Visitor

Hi Krishna

 

You can use bookmark to save the followings things: 

 

MorrisBI_0-1667413743394.png

Source

 

You might want to chance the "Heading"? I'm not sure what you mean with heading, does you mean the "Title" of a visual or "Header"?

 

Think in bookmarks as "Screenshot of what I see right now in my report page" because is just that.

 

If my guess is correct you should need a title based on filter selection, an old trick where you hide the original title of the (let´s say) a matrix or basic bar chart, and add a "Card" (Visualizations > Card) pointing to the actual filter.

You could save the state of the filter with bookmark, and then link that filter to the Card.

 

Hope this could help, if I'm wrong in my understanding please let me know, if not I will appreciate that you mark my answer as complete and of course, if you have any other questions don't hesitate to tag me.

 

Morris Bi

 

A useful video that you could see for aditional references:

 

 

Mastering Power BI Bookmarks 

 

View solution in original post

Hi Krishna

 

Got it... Here is the formula that you're looking for:

 

 

SELECTEDVALUE('TableName'[Column Name], "Alternative Text")

 

The alternative text is used when you don't have any selected value. Once you selected the value you want you need to save that bookmark.

 

Here are the steps:

 

1.- Create new measure with the formula above.

2.- Link this new measure with the graph: Visuals, Format, open Title section, click on "fx" button and drill down the "Base on field" and select your new measure, click ok.

3.- Save bookmark

4.- Enjoy your new report and take a good coffee.

 

Here is the complete tutorial, it's take 11 minutes but could be more useful for you because probably you would like to filter more than one field.

 

https://youtu.be/ZBDKIV-Lyz4

 

I hope this could solve your problem 🙂 

 

 

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Thanks for your help. It is resolved by using SelectedValue function.

Anonymous
Not applicable

Hi Morris, thanks for quick reply. Yes, I meant change a visual title based on book mark and what you select in a table below that - in my case for 2 Book marks - I have the same graph (in both the book marks)- but need different Titles based on a Hierarchy table below the graph) - 
In short is there a technical way to read what is selected in a Book mark and use it in DAX as a condition etc. That solves my issue .. Thanks Krishna

Hi Krishna

 

Got it... Here is the formula that you're looking for:

 

 

SELECTEDVALUE('TableName'[Column Name], "Alternative Text")

 

The alternative text is used when you don't have any selected value. Once you selected the value you want you need to save that bookmark.

 

Here are the steps:

 

1.- Create new measure with the formula above.

2.- Link this new measure with the graph: Visuals, Format, open Title section, click on "fx" button and drill down the "Base on field" and select your new measure, click ok.

3.- Save bookmark

4.- Enjoy your new report and take a good coffee.

 

Here is the complete tutorial, it's take 11 minutes but could be more useful for you because probably you would like to filter more than one field.

 

https://youtu.be/ZBDKIV-Lyz4

 

I hope this could solve your problem 🙂 

 

 

MorrisBI
Regular Visitor

Hi Krishna

 

You can use bookmark to save the followings things: 

 

MorrisBI_0-1667413743394.png

Source

 

You might want to chance the "Heading"? I'm not sure what you mean with heading, does you mean the "Title" of a visual or "Header"?

 

Think in bookmarks as "Screenshot of what I see right now in my report page" because is just that.

 

If my guess is correct you should need a title based on filter selection, an old trick where you hide the original title of the (let´s say) a matrix or basic bar chart, and add a "Card" (Visualizations > Card) pointing to the actual filter.

You could save the state of the filter with bookmark, and then link that filter to the Card.

 

Hope this could help, if I'm wrong in my understanding please let me know, if not I will appreciate that you mark my answer as complete and of course, if you have any other questions don't hesitate to tag me.

 

Morris Bi

 

A useful video that you could see for aditional references:

 

 

Mastering Power BI Bookmarks 

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors