Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
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.
@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)