Forum Discussion

ccrill23's avatar
ccrill23
New Member
4 years ago
Solved

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 ...
Need Help
  • bcdobbs's avatar
    bcdobbs
    4 years ago

    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.

bcdobbs's avatar
bcdobbs
Community Champion
4 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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?
  • bcdobbs's avatar
    bcdobbs
    Community Champion
    4 years ago

    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?