Forum Discussion
Sean
10 years agoCommunity Champion
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...
austinsense
10 years agoImpactful Individual
Little simpler, but you still have to repeat the expression IF ( [Measure], [Measure], 0 )
Virtual_Ames
10 years agoMicrosoft Employee
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