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 :)

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

Hi,

 

Yes, that is correct. I will try that. I was just hoping that I would not have to create a whole new column and instead just select a format or something like that on my Card. Something like "display blanks as "-" or display blanks as 0, etc. Power BI should have a function like that in order to minimize the amount of tampering with source data. :-)

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

Hi,

 

You dont have to worry about "amount of tampering". When you are creating custom columns it doesnt take any memory. Its one of the main benefits using DAX instead of Excel functions :)