Forum Discussion
Can`t replace 'NULL' vallue with empty cell?
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?
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.
3 Replies
null is a blank by definition. The value will be empty once loaded to the model
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.
