Forum Discussion
Helper IWaterfall chart help with start and end columns!
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 |
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.
3 Replies
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.
alexpegg86Hi Xianda,
I would like the chart to look like the below (one i created in excel):
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.