Canvas - Waterfall chart

I need a waterfall chart which I can use in canvas reports.
As the data I am showing is stored in the cube on different dimension elements I cannot use the native waterfall chart.
And the waterfall chart from the spreadsheet would work perfectly, but it does not work in canvas as the used dynarange does not open correctly. It works only on spreadsheets with a dynarange. View screenshots.