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,

IF's avatar
IF
Post Prodigy
2 years ago

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'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,