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

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

i have that same issue. I couldn't understand how did you solve that. Could you please share pbix if you have ? or tell again ?
Thanks.

  • 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 !