SWITCH statement not working properly

Hi Anonymous 

It can work correctly on my side.

Please check which version you use(there may be an issue with the previous version).

To make it works on your side, i would suggest you updating the lastest version.

https://docs.microsoft.com/en-us/power-bi/desktop-latest-update

 There is a workaround as below if you use the current version:

Create measures

Measure 1 = SWITCH(MAX(Table2[Trend]),"Up",1,"Down",-1,"Steady",0)

Measure 2 = 
VAR Down = UNICHAR (11167)
VAR Up = UNICHAR (11165)
VAR Equal = UNICHAR (61 )

RETURN
SWITCH (
TRUE(),
[Measure 1]<0, Down,
[Measure 1]>0, Up&" ",
[Measure 1]=0, Equal)

or create columns

Column 1 = SWITCH(Table2[Trend],"Up",1,"Down",-1,"Steady",0)

Column 2 = 
VAR Down = UNICHAR (11167)
VAR Up = UNICHAR (11165)
VAR Equal = UNICHAR (61 )

RETURN
SWITCH (
TRUE(),
[Column 1]<0, Down,
[Column 1]>0, Up&" ",
[Column 1]=0, Equal)

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.