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

lucasborges's avatar
lucasborges
New Member
8 years ago

I did it and it works but it shows like this:

 

 

How can I make the chart show only a single bar, the one with actual values?

  • HENRIQSI's avatar
    HENRIQSI
    Frequent Visitor
    8 years ago

    Hello Lucas,

    probably is the type of chart that you choose.

    Look like you selected Line and clustered column chart, when I choose Line and Stacked Column chart.

     

    • lucasborges's avatar
      lucasborges
      New Member
      8 years ago

      Thank you! You were right!