Waterfall chart help with start and end columns!

[alexpegg86]

Hi all,

Been trying to figure this out for a while now, and i can't find anything through google for what i'm trying to achieve... I think it's such a simple chart i'm trying to create yet not sure how to do it.

I want a waterfall chart with a start and end bar.

The start bar on the left will be last year's volume (Volume PY column), so 12,590 from the data attached.

The end bar on the right will be this year's volume (Volume TY column), so 12,218.

I want the columns in between to be made up of the Volume Change column (-372) to bridge the variance between the two, with each Customer being an increase or decrease bar in the chart.

I have seen some videos writing some DAX to get something similar to work, but it wasn't quite the same as what i was trying to achieve. Any help would be much appreciated!

See below the data:

Customer	Volume TY	Volume PY	Volume Change
Aldi	1,728,344	1,643,003	85,341
Asda	1,642,067	1,732,651	-90,584
Convenience Multiples	229,109	226,065	3,044
Iceland	472,467	519,883	-47,415
Independents	405,309	434,779	-29,471
Lidl	1,070,743	1,047,941	22,802
Morrisons	865,493	966,347	-100,854
Multiple Forecourts	172,547	164,181	8,366
Ocado	119,212	119,507	-295
Other Mult Grocers	284,596	293,285	-8,690
Sainsbury	1,135,158	1,241,223	-106,065
Symbols	748,274	752,406	-4,131
Tesco	2,688,217	2,754,543	-66,326
Total Co-Operative Group Kad	446,459	462,815	-16,356
Waitrose	210,122	231,513	-21,391
TOTAL	12,218	12,590	-372

[Anonymous]

Hi @alexpegg86 ，

Can you give us a diagram of your expected results?

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[alexpegg86]

Hi Xianda,

I would like the chart to look like the below (one i created in excel):

[Anonymous · Accepted solution]

Hi @alexpegg86 ,

You can create a secondary column that sorts your customers' first names from smallest to largest , below is that:

Then you filter with bottom in the filter:

The final output is like this:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.