Forum Discussion

ktt777's avatar
ktt777
Helper 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.

3 Replies

  • HashamNiaz's avatar
    HashamNiaz
    Solution 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

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.