Forum Discussion

Frixel's avatar
Frixel
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

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?...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    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.

v-angzheng-msft's avatar
v-angzheng-msft
Icon for Community Support rankCommunity Support
4 years ago

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.