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

Get 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

Reply
olives
Helper I
Helper I

How to show SELECTEDVALUE in the title?

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

 

olives_0-1686714655404.png

olives_1-1686714732565.png

 

Thanks in advance.

 

Regards

6 REPLIES 6
C4YNelis
Advocate III
Advocate III

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
Helper I
Helper I

@PhilipTreacy 
Thank you for your help.

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

 

olives_0-1686730920982.png

 

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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


olives
Helper I
Helper I

@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.

 

olives_1-1686728880372.png

 

 

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])

 

selsum.png

 

Regards

 

Phil

 



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


PhilipTreacy
Super User
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.

 

slctd.png

 

Regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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