The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
I would like for my text box to read this...
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
Solved! Go to Solution.
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.
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.
Thank you for this. When using this formula, it says the syntax for 'Return' is incorrect.
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?
User | Count |
---|---|
40 | |
15 | |
13 | |
11 | |
8 |
User | Count |
---|---|
47 | |
43 | |
23 | |
19 | |
18 |