4 Replies Latest reply: Aug 20, 2015 4:43 AM by Anusha K RSS

    Line Chart Color Coding Issue

    Anusha K

      Hi Team,

      I've line chart(Added Circle as Symbol) with 'Year' as Dimension and 'Sum(Sales)' as Measure . when I selected one year it displays last four years data.My requirement is selected year sales are less than previous year it has to show Red color for that year line as shown in image. Issue  is the end of the line chart also display red if the line is red but it displays as green. Color code is given in Expression tab->Background color as

      =if(yearend(max([Year1]),-1)=yearend(max([Year]),-2) ,

          if(

             $(Sales_YTD)-$(Sales_PrevYTD)>0,

          RGB(0,176,80), RGB(192,0,0)),

          RGB(0,176,80)

      )

      Please any one help me for resolving this issue.
      LIne1.png