12 Replies Latest reply: Feb 2, 2018 9:50 AM by Sunny Talwar RSS

    Color consistency b/w Bar chart vs Pie Chart

    Selva A

      Hi ,

       

      I have a requirement like below.

       

      I want to show the same color for Pie chart as well as bar chart.

       

      Dimension for  Bar chart --  I used 2 dimensions (Month Name (Jan-17).... Dec-17 ,Days)


      Days Dimension -- I have used 

       

      if([xyz] <=1, 'Below 1 day'

      ',if([xyz] <=3,  'Below 2-3 day'

      ',if([xyz] <=7,'Below 3-7 day'

      ',if([xyz] <=17,'Below  8-17 day'

      ',if([xyz] <=30, 'Below 18-30 day'

      ,above 30 days

      )'))))



      Measure - Used    Count([xyz])+ 0 * Count([xyz])



      Same thing for pie chart also


      I used color by expression in both charts

       

      if([xyz] <=1, Yellow()

      ',if([xyz] <=3, blue()

      ',if([xyz] <=7, Green()

      ',if([xyz] <=17, brown()

      ',if([xyz] <=30, red()

      ,Red()

      )'))))

       

      But still it's not coming correctly. Kindly help me on this

       

      Thanks in Advance