Forum Discussion

HENRIQSI's avatar
HENRIQSI
Frequent Visitor
8 years ago
Solved

Column + line chart

Hello, I have a chart with Columns (Month results) + lines (month goals). Someone knows how to put a color conditional for de columns when its up or down the goal line? Like, green for values upper...
  • HENRIQSI's avatar
    HENRIQSI
    8 years ago

    Problem solved!
    Just for information, I created  2 new measures, conditioned (Productive good = IF([Productive3]>[Goal3];[Produtictive3];0) and (Productive bad = IF([Productive3]<[Goal3];[Produtictive3];0). 


    Ps: Indicators MUST be in Measures with Sum function

     

    Ex. [Productive3] = DIVIDE ([Production3];[Worked hours3];0)]

         [Production 3] = SUM (Plan1[Production]);

         [Worked hours3] = SUM (Plan1[Worked hours])

         [Goal3] = SUM (Plan1[Goal])

HENRIQSI's avatar
HENRIQSI
Frequent Visitor
8 years ago

Hello,

 

Well I have a Collum (month values) + Line (month goals) chart.

Someone knows how to put a conditional to change the collor of the columns of my chart, if it up (green) or down (red) the line?

Thx.