Show Sub Totals in Waterfall Chart to reflect existing Excel Chart

[RichardJ]

Hi,

This excel chart shows the unit price for a product (using a stacked bar but hiding the lower portion of the bar for most of the bars)

I've been trying to use the out of the box Waterfall chart to generate the sub totals (Baseline, 2019 Mid Year, 2019 Forecast) shown above but have been struggling to do so.

Is there a way I can restructure the data to be able to show the sub totals? or any other suggestions as to how to achieve the requrement. I had a look at the 'Ultimate Waterfall' chart add in but would like to stick to out of the box Power BI if possible.

The data for the Power BI Chart shown above is

Description	Timeframe	Cumulative	Running Total
Category 1	Baseline	5.00	5.00
Category 2		0.50	5.50
Category 3		0.30	5.80
Category 4		0.02	5.82
Category 5	2019 Mid Year	0.40	6.22
Category 6		0.20	6.42
Category 7		-0.30	6.12
Category 8		0.05	6.17
Category 9	2019 Forecast	0.23	6.40

Thanks,

Richard  

[amitchandak · Accepted solution]

@RichardJ , You might have to check for some custom visual

refer : https://xviz.com/visuals/waterfall-chart/

[RichardJ]

Thanks @amitchandak  for clarifying that i'll need an add on.

The add you suggested seems simple to use compared to the 'Ultimate Waterfall' version i'd previously looked at and provides the functionality required.

Appreciate you getting back to me on a Sunday!