Display blank and 0

[ktt777]

Hi All

The blank space in below column is 0% , but power bi shows it as blank .

How can i set to show 0 insteas of blank

thanks, 

[Anonymous · Accepted solution]

Hi @ktt777 

The most convenient way is to add a measure to determine whether the value is a null value, if it returns 0, if not, return the original value .

Measure = IF(SELECTEDVALUE('Table'[Value])=BLANK(),0,SELECTEDVALUE('Table'[Value]))

The effect is as shown :

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HashamNiaz]

Hi @ktt777 !

You can write your measure using ISBLANK() shown in below DAX;

Sales = IF(ISBLANK(SUM(Table[Sales])), 0 , SUM(Table[Sales])

Regards,

Hasham

[amitchandak]

@ktt777 , add +0 to the measure and try