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 same colour what's written next to it. The circles are "UNICHAR(11044)". I wanted to use this function, as it is now a text format and not a number format.
Any help is greatly appreciated!
Bests,
Ada
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
2 Replies
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