Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Blank Visuals

Hi Team   I have a bar chart and upon selecting certain values values in slicer it goes blank. I have used the ISBLANK() in the measure that is being used in the bar chart. Is there a way to show l...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Team

 

Anyone with an idea for this issue. 

Thejeswar's avatar
Thejeswar
Icon for Super User rankSuper User
8 years ago

Hi Anonymous,

You can use the below DAX Statement

 

Measure1 = IF(ISBLANK(Measure),0, Measure)
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Thejeswar

     

    I have already used this in DAX but the visuals still go blank upon slicing.

    • Thejeswar's avatar
      Thejeswar
      Icon for Super User rankSuper User
      8 years ago

      Hi Anonymous,

      I tried replicating your scenario. But I am not able to replicate it

       

      Here is my screenshot in two cases

       

      1. When the data is not slicedAll the data is displayed

       2. When the data is slicedThe Pack Size 2-GPI still has the quantity to be blank

       In the above 2 cases, Measure and Measure2 column values are unchanged.

       

      Here the Measure column is the one where the Blank is handled using the below DAX statement

       

      Measure = IF(ISBLANK(SUM('Merge Table'[Quantity])),0, SUM('Merge Table'[Quantity]))

      The Measure2 is without BLANKs handled

      Measure 2 = SUM('Merge Table'[Quantity])

      In both the cases, the data looks fine.