Still hoping for an easier way - if not, perhaps this would be a feature request as this seems to imply that for every card where I do not want to see "(BLANK)" when certain filters are applied - I need to create a new measure and apply the IF
As sugegsted by @Sean and @MattAllington, we need to use =IF(ISBLANK...) to force blank values as 0. Or you can replace all blank values as 0 when you retrieve data from source table. Currently, the Card visualization will not trace blank value as 0.
If you have any question, please feel free to ask.
Best Regards, Qiuyun Yu
Community Support Team _ Qiuyun Yu If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have a list of stores in my rows, and time period as columns. Some periods, don't have data, some do. The ones that don't have any data (No Values) show up as blanks. I want to seed the blanks with 0's