Forum Discussion

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , By default that should be the behavior. Have you added +0 to any measure. Or used option- Show item with No Data?

You can add a visual level filter [Load **bleep**] <> 0

 

Uncheck

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    amitchandak, thanks for reverting. The filter for "Show items with no data" was always unchecked. The visual level filter does help, however I was looking for some DAX Code here. Also, yes I have displayed (Blank) as 0 for the field "Load Count", as I have a Card visual created for this field too, where I would like to display "Blank" as "0". Hence, was searching for an option where I don't have to use visual filter nor have to revert the code for Load Count from 0 to Blank. Can you please help here?

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      5 years ago

      Anonymous , Have a measure 

      if( [Load Count] =0 , blank(),[Load Count])