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.
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! 😉
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.
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.
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.