Forum Discussion

ktt777's avatar
ktt777
Icon for Helper V rankHelper V
5 years ago
Solved

Display blank and 0

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,   
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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's avatar
HashamNiaz
Icon for Solution Sage rankSolution Sage
5 years ago

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