Argument 8 in SWITCH function is required

[Anonymous]

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

[Greg_Deckler · Accepted solution]

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.

[v-yulgu-msft · Accepted solution]

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

[Greg_Deckler · Accepted solution]

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.