Nulls formatting

[vireshkolagimat]

Hi All,

I have the below data and i would like to show 100% wherever the value fullfilled is Null(-).

I tried the expression like if(isnull([Value Fullfilled]),'100%',[Value Fullfilled]) but not getting the expected result.

Thanks.

[YoussefBelloum]

Hi,

you can try this, you will found it  at the bottom of the presentation tab of this type of chart you're using:

you can replace null values and missing values.

[vireshkolagimat]

Hi, I tried the above steps but it doesn't have any effect. These setting will apply to the whole chart.

But i need to format only the value fulfilled column.

Thank you.

[Thiago_Justen_]

What about this:

If(len(trim([Value Fullfilled]))= 0 or [Value Fullfilled]='NULL' or [Value Fullfilled] ='-', '100%', [Value Fullfilled])

[YoussefBelloum]

I would suggest this:

If(len(trim([Value Fullfilled]))= 0 or [Value Fullfilled]='' or isnull([Value Fullfilled]), '100%', [Value Fullfilled])

[Thiago_Justen_]

Handling with null values ​​is more complicated than we sometimes imagine.

[vireshkolagimat]

Hi thank you. Its working as expected.

[vireshkolagimat]

Yeah it worked. thanks

[YoussefBelloum]

You're welcome !

don't forget to close the thread by marking correct and helpful answers

[vireshkolagimat]

yes i did.