Blank or null value

[Anonymous]

Hello,

In a dashboard, sometimes we have blank values and other times we have null value.  Is there a difference between blank and null in a table?

If we want to stay consistent, is it possible to choose only blank or null value and if so how do we do that?

Regards

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may also take a look at the following links.

• https://www.sqlbi.com/articles/blank-handling-in-dax/
• https://www.sqlbi.com/articles/how-to-handle-blank-in-dax-measures/

[tex628]

A value displayed as null in power query should be converted to a blank in report view. Are you certain the values are not in string format? 

[Anonymous]

I will check that