Forum Discussion

Sean's avatar
Sean
Community Champion
10 years ago

Blank( ) in Card/Multi-row Card

Is there an easier way to output 0 instead of blank in a card / multi-row card   I've been using => IF ( ISBLANK (expression), 0, expression )   Is there any way to avoid repeating the expression...
Need Help
austinsense's avatar
austinsense
Impactful Individual
10 years ago

Little simpler, but you still have to repeat the expression IF ( [Measure], [Measure], 0 )

  • LLABROOY's avatar
    LLABROOY
    New Member
    9 years ago

    I'd also be interested in how to remove (Blank)

     

    This is made up of individual Card vizulisations and i have lutiple different revenue and count cards over my report that i would need to create a measure for to remove (Blank) Is there a way to create a report level filter or at least page level filter that changes this to some relevant '0' or '-' . 

     

     

     

    • shebr's avatar
      shebr
      Resolver III
      8 years ago

      Hi LLABROOY,

       

      Have you tried doing a 'replace' in your query editor, see image below. If you right click on the column and replace null with 0, this may resolve your issue.

       

      Let me know how you get on.

       

      Thanks

       

      shebr

       

  • Virtual_Ames's avatar
    Virtual_Ames
    Microsoft Employee
    10 years ago

    Austin,

     

    Great reply, thanks. This would mean that for every card on a dashboard where I do not want to see "BLANK" - I need to create a new measure and apply this IF. Is that correct? Or is there some way to have this act as a global setting?

     

    Best, and thanks again.

     

    Brian