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])

pxg08680's avatar
pxg08680
Resolver III
8 years ago

HENRIQSI

First thing is , is your goal line fixed..?

 If yes, use the same column Productive... and put it in the colorSaturation field and go to data color section. Select the diverging option and put the center value as you goal line value.

 

Hope this solves your problem.

HENRIQSI's avatar
HENRIQSI
Frequent Visitor
8 years ago

Unfortunately my goal line isn't fixed...

And in the Column + line chart option there is no ColorSaturation option =/