topic Re: heading based on bookmark selected - is it possible in DAX Commands and Tips

heading based on bookmark selected - is it possible

Anonymous — Wed, 02 Nov 2022 18:00:51 GMT

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

Re: heading based on bookmark selected - is it possible

MorrisBI — Wed, 02 Nov 2022 18:40:39 GMT

Hi Krishna

You can use bookmark to save the followings things:

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

Re: heading based on bookmark selected - is it possible

Anonymous — Wed, 02 Nov 2022 23:07:08 GMT

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

Re: heading based on bookmark selected - is it possible

MorrisBI — Fri, 04 Nov 2022 16:36:34 GMT

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 🙂

Re: heading based on bookmark selected - is it possible

Anonymous — Tue, 22 Nov 2022 20:25:03 GMT

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