How to show SELECTEDVALUE in the title?

[olives]

Hi, I am trying to show selected value (category) in the title.

I would like to be able to display "You have selected ________."
I was able to display it in the visual of the Card, but when I displayed it in the title, it failed to display.

Selected Category = 
 VAR _Sel =SELECTEDVALUE('Product'[Category]) 
 Return "You have selected " & _Sel

Thanks in advance.

Regards

[C4YNelis]

Hi @olives ,

I believe you are right in that you can't. I've experienced the same problem using a slicer to select a language to dynamically change all the titles of every visual to the selected language. It works for every title, except for the one of the slicer that you used to select the language with. It seems slicers (or visuals in general) are not able to affect there own state at this level, only the state of other visuals.

If you ever find a workaround, please let me know! 😉

Cheers,

Niels

[olives]

@PhilipTreacy 
Thank you for your help.

This works on card, but still, it does not work on the title.😅
But thanks for the advice😄

[PhilipTreacy]

Hi @olives 

At least you have a working solution to the problem.  Grouping the card and visual isn't a big issue.  You can use the same approach in Excel.

Phil

[olives]

@PhilipTreacy 
Thanks for the advice 😊

Is there any other way than grouping using cards?
Actually, what I really want to do is not to display the selections, but to show the total value of the selections.
There are many examples of displaying the total of what I have narrowed down in slicer, but I want to do with clicking on a bar or legend in the graph and show it to title.

[PhilipTreacy]

Hi @olives 

Download example PBIX file

No that I'm aware of.

To show the total value of selections you can use a measure like this

Selected = "You have selected " & SUM('DataTable'[Value])

Regards

Phil

[PhilipTreacy]

Hi @olives 

Hmmm, doesn't seem that you can do it which is kinda odd really seeing as you can show the selected category in  a Card.

Try turning off the Title then place a card over the visual and group the card and visual together.

Regards

Phil