Forum Discussion
Argument 8 in SWITCH function is required
Hey guys, I would need your help in a DAX Measure function. I'm totally new to Power BI and found this function on YouTube. What I would like to do: The field "KPI Colour Name" is getting the...
Either get rid of your last ";" in your SWITCH statement or add a value at the end that the SWITCH statement should return if none of the conditions are met.
Hi Anonymous,
There is no green circle and yellow circle in unicode. For red circle, you can use UNICHAR(128308).
For your requirement, you could add black circle into visual, then, change its color in conditional formatting.
Create below measures:
KPI value = var color=SELECTEDVALUE(Table1[Color]) return SWITCH(TRUE(), color="green",1, color="red",2, color="yellow",3) KPI indicator = UNICHAR(11044)Best regards,
Yuliana Gu
Hi Anonymous,
There is no green circle and yellow circle in unicode. For red circle, you can use UNICHAR(128308).
For your requirement, you could add black circle into visual, then, change its color in conditional formatting.
Create below measures:
KPI value = var color=SELECTEDVALUE(Table1[Color])
return
SWITCH(TRUE(),
color="green",1,
color="red",2,
color="yellow",3)
KPI indicator = UNICHAR(11044)
Best regards,
Yuliana Gu