3 Replies Latest reply on May 3, 2018 7:31 PM by sudheer.kumar.5

    Hide null values in piechart

    Rossella Blatt Vital

      Hi,

       

      how can I hide null values from a piechart?

      When the measure used as angle is null, then the view instead of being empty has a thin line of the color corresponding with the dimension with the null value (that dimension is used to color the angles). I tried creating a calculated field that substitute null with 0, but I still have the same issue.

       

      Below the behavior (correct) when both measures are not null, the behavior (wrong) when one measure is null and the behavior (wrong) when one measure is 0.

       

      1) BOTH MEASURES NOT NULL (PIECHART CORRECT)

      1.jpg

       

      2) AT LEAST 1 MEASURE NULL: ISSUE


      2.jpg

       

      3) AT LEAST 1 MEASURE 0: ISSUE


      3.jpg

       

      Any idea why this is happening and how to avoid it?

      Thanks

      Rossella