Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
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
@PhilipTreacy
Thank you for your help.
This works on card, but still, it does not work on the title.😅
But thanks for the advice😄
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
Proud to be a Super User!
@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.
Hi @olives
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
Proud to be a Super User!
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
Proud to be a Super User!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
93 | |
90 | |
84 | |
70 | |
49 |
User | Count |
---|---|
141 | |
121 | |
112 | |
59 | |
58 |