Forum Discussion

CalvinBB01's avatar
CalvinBB01
Frequent Visitor
2 years ago
Solved

Blank value after filter condition

here i have below issue:   when there's no data with the filter, the value will be Blank. If I change it to " if(isblank(Value), 0, Value)", then it will present 0 which is fine. but when I creat...
  • ChiragGarg2512's avatar
    ChiragGarg2512
    2 years ago

    Use Card(new) visual    in that in callout value section there is an option on what to display when the vaue is blank.

     

     

     

ania_roh's avatar
ania_roh
Icon for Helper III rankHelper III
2 years ago

Hello,

If you change the measure like that, the chart will always show zeros. 

You have two solutions:
- put filter in the panel filter with the measure is not 0 :

- or create two different measures: one for the chart (leaving it as blank) and another for a card

 

Also, I recommend you use :
[Value] + 0
istead of:
 if(isblank([Value]), 0, [Value]

It is the same thing but it is more efficient.