Forum Discussion

IF's avatar
IF
Post Prodigy
2 years ago
Solved

UNICHAR WITH NO VALUEundefined

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...
Need Help
  • lucadelicio's avatar
    lucadelicio
    2 years ago
    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,

lucadelicio's avatar
lucadelicio
Impactful Individual
2 years ago
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's avatar
IF
Post Prodigy
2 years ago

Wonderful! it is working, thank youuu.

  • lucadelicio's avatar
    lucadelicio
    Impactful Individual
    2 years ago

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