Forum Discussion
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...
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 functionEx. [Productive3] = DIVIDE ([Production3];[Worked hours3];0)]
[Production 3] = SUM (Plan1[Production]);
[Worked hours3] = SUM (Plan1[Worked hours])
[Goal3] = SUM (Plan1[Goal])
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.
Thank you! You were right!