Search code examples
powerbipowerbi-desktoppowerbi-datasourcepower-bi-report-serverpowerbi-custom-visuals

When we sum column value in power bi table, if value is null or blank then how to show it as 0 in power?

In my Power BI Dashboard table after creating dashboard if some row values are empty then how to make it as 0 instead of Null or Blank value

enter image description here

Solution

  • If date field is missing then 

    Date =

VAR MCON = FORMAT(TODAY(),“dd/M/yyyy")

RETURN TF(
          SELECTEDVALUE('New Registration'[$1]) = BLANK(),
          MCON, 
          SELECTEDVALUE('New Registration'[$1])
         )

    Result

    enter image description here