Forum Discussion
Column + line chart
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])
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])
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?
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?
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!
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.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).
Thank you so much. i got it !
