Power BI - matrix shows blank or 0M

[joseph248]

HI All,

I need help, on the Power BI Matrix, I have change the unit to Million,

However, I have some field showing blank and other 0M

I realized the on showing 0M (I mannually input a value 0.01)

The blank field is when the excel data show 0.00.

How do I make Power BI matrix to realized if is 0.00 it input 0M as well rather than me going into excel to put 0.01 on it.

see picture below. Thank you.

[v-zhenbw-msft · Accepted solution]

Hi @joseph248 ,

We can create a measure to meet your requirement.

Measure = SUM('Table'[value])+0

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?

Best regards,

Community Support Team _ zhenbw

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

BTW, pbix as attached.

[Greg_Deckler]

@joseph248 Perhaps fix this in Power Query by adding a step to replace blanks (null) with 0 or in DAX:

Measure =
  VAR __Calc = <some calc>
RETURN
  IF(ISBLANK(__Calc),0,__Calc)