Replace blank with 0 in matrix

[Harry_Tran]

Hi everyone,

Does anyoe know how to replace blank with 0?

I have try +0, if(isblank, if( = blank(),0) but it not work.

TIA

[PijushRoy]

Hi @Harry_Tran 

Please try
IF(Your Measure = 0, "0", Your Measure)
or
IF(Your Measure = 0, " "&"0", Your Measure)
or

COALESCE(Your Measure,"0")

If you have any question, please let me know.
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos

Regards
Pijush

[v-henryk-mstf · Accepted solution]

Hi @Harry_Tran ,

I think you can convert quickly in the power query.

Or try the formula like bleow

Column = IF('Table'[Col_1]=BLANK(),0,'Table'[Col_1])

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your feedback.

Best Regards,
Henry

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

[Jihwan_Kim]

Hi,

I am not sure without seeing your datamodel, but please try to create a measure with using double-equal sign "== blank()".

I happened to face some of the situations that a Blank shown on a visualization is not actually a blank. In that case, I tried using "== blank()", instead of using "=blank()"  

[amitchandak]

@Harry_Tran , Simply add +0

or coalesce([Column/measure],0)

But this is more successful ,when you group by/axis/row from dimension

[Anonymous]

@amitchandak  Can you elaborate on this? I'm facing the issue where when I use the coalesce or IF(ISBLANK approaches, many extraneous rows are added to my table visualizations.