The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
36 | |
15 | |
12 | |
11 | |
9 |
User | Count |
---|---|
46 | |
44 | |
20 | |
19 | |
18 |