Forum Discussion

Espen1515's avatar
Espen1515
Icon for Advocate I rankAdvocate I
8 years ago
Solved

Replacing (Blanks) with 0

Hi,   I have a number of Cards in my dashboard that return numbers. When I selected a filter where there no numbers, instead of displaying 0, it displays (Blank), and looks very ugly. Is there an e...
Need Help
  • Pavlous's avatar
    Pavlous
    8 years ago

    Espen1515,

    so you are using the raw source data, is it correct?

     

    So its easy to you just make new column with this code

     

    Column = IF(ISBLANK(**original column**),0,**original column**)

    **original column** - your name for the column you are using.

    Then change the value to the new column and it should work :)

Pavlous's avatar
Pavlous
Icon for Advocate II rankAdvocate II
8 years ago

Espen1515,

so you are using the raw source data, is it correct?

 

So its easy to you just make new column with this code

 

Column = IF(ISBLANK(**original column**),0,**original column**)

**original column** - your name for the column you are using.

Then change the value to the new column and it should work :)

deSanta's avatar
deSanta
Regular Visitor
4 years ago

Hi, I am very new to Power Bi, and I have a similar problem. However I have multiple columns on my data field, and I want to put zeros on the empty spaces. Is there a way to set a singe rule that runs on the entire field?

 

Thanks on advance.