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,
I have a waterfall chart where I'm starting from last year's revenue and having different categories to walk to my current revenue.
In the chart below, is there a way to have subtotal of Prior Revenue and Categories 1 to 4 and have it show before Category 5? Basically I want a bar in between Category 4 and 5 below as a subtotal of everything before it. Sample data also included below.
CategoryAmountSort Order
Prior Revenue | 10000000 | 1 |
Category 1 | -1000000 | 2 |
Category 2 | 1500000 | 3 |
Category 3 | -500000 | 4 |
Category 4 | -300000 | 5 |
Category 5 | 2000000 | 6 |
Solved! Go to Solution.
It is possible but you need to use custom visuals and you need to massage your data accordingly.
Might be easier to do with Deneb.
See attached.
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |