Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
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?
Thank you.
Hi Nikonnet,
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?
Regards,
Jimmy Tao
Hi,
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |