I would like to use stacked column with line chart to show Total forecasted revenue (as superset) and Total earned revenue as "subset" within total forecasted revenue. The line chart to show the Goal.
The goal and the earned value are showing correctly. However, for total revenue, I would require the "visual" as Sample 1 but the value as in Sample 2. Any way to do it?
How do you describe superset or subset? Have you created any measure about 'Total earned revenue'? Could you share some sample data and clarify more detials?
Sample data: Goal = 1.87M, Total revenue (Apr 2018 to Mar 2019) = 1.71M, Total earned revenue till date = 1.45M.
Visually i want:
- Triangle to show the goal = Done with no issues
- Total earned revenue till date = Done with no issues
- Total revenue = It is either show full 1.71M instead of the height of 0.26M (1.71M - 1.45M) but data label of 1.71M.