UNICHAR WITH NO VALUEundefined

[IF]

Hi,

I use unichar to show the values with icons. When there is no value, i see the icon "(BLANK" which i don't like. I tried different things but it didn't work. Here is my measure:

Arrow_K =

VAR down = UNICHAR(9660)

VAR slightdown = UNICHAR(9660)

var slightup = UNICHAR(9650)

VAR up = UNICHAR(9650)

VAR same = UNICHAR(9866)

VAR DIF = [AVE] - [Previous]

RETURN

SWITCH(TRUE(),

       DIF<=-0.01, up,

       DIF > 0.01, down, "-")

If i would not use switch, i know how to do it such as:

measureworks =

VAR calc=

calculate(SUM......)

Return

If(ISBLANK(calc), "N/A", calc)

However i could not succeed with it, when i use switch. can you help me on this?

thanks in advance

[lucadelicio]

Hi,

can you upload a the pbix on https://wetransfer.com/

I will help you.

Luca D'Elicio

[IF]

Hi,

I made a simple pbix file. If there is no value, the arrow should be "n/a" or should not show down or up. This selection doesn't have value, which i showed with the card. However, the arrow is down. The file is loaded here. thanks in advance. https://we.tl/t-uCXGWX8Mcn

[lucadelicio · Accepted solution]

Arrow =

VAR down = UNICHAR(9660)

VAR up = UNICHAR(9650)

VAR DIF = [SumPred] - [SumQty]

RETURN

SWITCH(TRUE(),

       ISBLANK(DIF), "",

       DIF<=-0.3, up,

       DIF > -0.3, down,  "-")

Try this measure.

IF I RESOLVE YOUR PROBLEM PLEASE MARK IT AS A SOLUTION

Regards,

[IF]

Wonderful! it is working, thank youuu.

[lucadelicio]

So easy!
With PowerBi you have to use Logic and Fantasy!
Have a nice day,