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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Fusilier2
Helper I
Helper I

Trying to return a text statement in a card visual

Hi,

I have a report with a visual where the Y-Axis is determined by a selection in a Slicer combined with a Parameter:

Number of Absences

Hours Absent

FTE Days Lost

 

I want the card visual to show the option selected in the slicer

 

I have a measure as follows in the card:

Filtered Measure = SELECTEDVALUE('ParameterY-Axis 3'[ParameterY-Axis 3 Fields])
 
to return the selected value in the card
 
However the text displayed is the full name of the measure. e.g.
'Monthly Sickness Data'[Sum of FTE days lost]
when I want it to just show the text as  FTE days lost.
 
I thought it might be possible to convert 'Monthly Sickness Data'[Sum of FTE days lost]
to text and combine with an if statement to show the text as I want (something like: if value = Monthly Sickness Data'[Sum of FTE days lost], 'FTE days lost,"")
But I can't work out how to get the measure to work.
 
Can anybody help or is there an alternative method of obtaining the result I am after?
 
Thanks

 

 

 

1 ACCEPTED SOLUTION
_AAndrade
Super User
Super User

Hi @Fusilier2,

You can do it by adding a new column on your parameter table and put the names you want.
Take a look at this my example:

_AAndrade_0-1712141965718.png


I've added a new column "ParamName" and put Name A and Name B. After that I used only this measure:

Name Selected = SELECTEDVALUE(Parameter[ParamName])

And put it on a card, the final output is this:
ParamName.gif





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




View solution in original post

2 REPLIES 2
Fusilier2
Helper I
Helper I

Thank you very much. That works!

_AAndrade
Super User
Super User

Hi @Fusilier2,

You can do it by adding a new column on your parameter table and put the names you want.
Take a look at this my example:

_AAndrade_0-1712141965718.png


I've added a new column "ParamName" and put Name A and Name B. After that I used only this measure:

Name Selected = SELECTEDVALUE(Parameter[ParamName])

And put it on a card, the final output is this:
ParamName.gif





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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