Forum Discussion
Solved
Misleading Stacked Column Chart
I am having a hard time understanding how to get this chart to reflect accurately. Please take a look at the example below: My actual values is 228,354.62 and my target is 300k. That's 7...
You are actually stacking Actual and Target values!. I supose that you want to show the difference between both values.
So you must create a measure DIF = SUM(Target)-SUM(Actual) and use that measure in your chart instead of Target.
Regards!
EDIT: I recommend to put Target on chart's Tooltip for showing that value too on mouse hover.
You are actually stacking Actual and Target values!. I supose that you want to show the difference between both values.
So you must create a measure DIF = SUM(Target)-SUM(Actual) and use that measure in your chart instead of Target.
Regards!
EDIT: I recommend to put Target on chart's Tooltip for showing that value too on mouse hover.
Great explination, CrisYan. Your approach solved it for me.
Thank you so much