Forum Discussion
IF
Post Prodigy
Post ProdigyUNICHAR 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 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
- Arrow =VAR down = UNICHAR(9660)VAR up = UNICHAR(9650)VAR DIF = [SumPred] - [SumQty]RETURNSWITCH(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,
5 Replies
lucadelicioImpactful Individual
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
- lucadelicioArrow =VAR down = UNICHAR(9660)VAR up = UNICHAR(9650)VAR DIF = [SumPred] - [SumQty]RETURNSWITCH(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,