cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Helper I

## SWITCH statement not working properly

I have the following SWITCH statement as a new column:

teperatureTrendChar =
VAR Down = UNICHAR ( 11167 )
VAR Up = UNICHAR ( 11165 )
VAR equal = UNICHAR ( 61 )

RETURN
SWITCH (
TRUE (),
BMSState[temperatureTrend] = "Down", Down,
BMSState[temperatureTrend] = "Up", Up,

This should return a DOWN ARROW, EQUALS SIGN, UP ARROW based on the value of [temperatureTrend].  However, you can see from the image below that regardless of whether the value is "Down" or "Up" it returns the same value. Don't quite know what is going on here?

1 ACCEPTED SOLUTION
Community Support

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.

5 REPLIES 5
Community Support

Is this problem sloved?

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please let me know.

Best Regards

Maggie

Helper I
Thanks - had to use the workaround as I am running latest version of PowerBI Desktop already. BTW - can you tell me why you add a space for the Up check? Up&" "
Community Support

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.

Anonymous
Not applicable

@banthorpe - That looks like it should work - can you provide a sample table or pbix?

Thanks,

Nathan

Helper I

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors