Can`t replace 'NULL' vallue with empty cell?

[Frixel]

Hi all,

How is it possible to replace "null"  values to a empty cell.

It is not possible to let the Replace Value fill in with nothing, the the attention remarks comes.

How can i solve this? 

[v-angzheng-msft · Accepted solution]

Hi, @Frixel 

When you click apply, so null values are just not visible in power bi.
If you just want to implement replacing the null value in the PQ, then you can do this.
First replace the null value with any value of type numeric (e.g. 0), then change the M code at the top.

Replace 0 with "Character.FromNumber(8203)"

Note that when you click Apply, the type of this column in the power bi is text. If you need to do calculations, you may need to use functions such as if,value to convert text to numeric types.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[KNP]

Hi @Frixel,

If you want to do that on a column with a number type you'll need to use a zero as blank would clash with the type.

Hope that helps.

Regards,

Kim

[PaulDBrown]

null is a blank by definition. The value will be empty once loaded to the model