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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ccrill23
New Member

Dynamically change text box based on slicer selection

Hello, 

I am currently building a dashboard for my hospitals call centers and would like for the information in my text box to change based on what I have selected in my slicer. 

 

So when I have WMC Selected

ccrill23_2-1638906091522.png

I would like for my text box to read this...

ccrill23_1-1638906062698.png

 

and when I have other call centers besides "WMC" selected I would like for the text box to remain blank. 

Is this possible to do? Thank you 

1 ACCEPTED SOLUTION
bcdobbs
Community Champion
Community Champion

Try something like the following measure:

 

 

VAR CallCentre = SELECTEDVALUE( Table[Call Centre], BLANK() )

RETURN

IF ( CallCentre = "WMC", "Your Text", BLANK() )

 

 

then drop the measure into a card visual.



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

View solution in original post

3 REPLIES 3
bcdobbs
Community Champion
Community Champion

Try something like the following measure:

 

 

VAR CallCentre = SELECTEDVALUE( Table[Call Centre], BLANK() )

RETURN

IF ( CallCentre = "WMC", "Your Text", BLANK() )

 

 

then drop the measure into a card visual.



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Anonymous
Not applicable

Thank you for this.  When using this formula, it says the syntax for 'Return' is incorrect.

VAR CallCentre = SELECTEDVALUE('Cost Centers'[Call Center ], BLANK() )
RETURN
IF ('Cost Centers'[Call Center ], = "WMC", "Test", BLANK() )
What are we doing wrong?

So in the if statement you've got a comma between Cost Centers'[Call Center ] and equals.

Also worth checking the white space after [Call Center ] eg does your column end with a space?



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.