2 Replies Latest reply on Sep 28, 2018 8:55 AM by arvindgarg

    Change one slice of pie chart based on a condition

    Dhwani C

      Hi Guys,

       

      I have a project where a client would like to see % Achieved (calculated field) on a pie chart. I do this by creating another calculation [1-Achieved%] and follow the steps to get the pie chart.

       

      I need the % Achieved slice to show as Green if it's over 80% and Red otherwise. I can't post the original workbook so I've tried to replicate the scenario with the Superstore data (as attached).

       

      I'm not able to get all 3 colours into one calculation.

       

      Thanks!