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
7 years ago

I just created 2 new measures. The first is for the results bigger than goal, and the second is for results smaller than goal.

So, instead of plot the result measure, plot the 2 new measures and the goal, and define a color for each measures (in my case, green for good and red for bad).

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thank you so much. i got it !