Waterfall chart show Start and End totals based on absolute values

[dosania]

Hi,

I'm trying to make a Waterfall chart for my company to show the start and end balances throughout the month.

They would like to explicity like to call out the start and end values using the bars like we do in excel, but I am unabe to do this.

I have tried to reform the data, and also write new measures to do this, which is below.

Rolling total =

var _group =

max('Test Table'[Value])

RETURN

CALCULATE([Test], 'Test Table'[Value] <= _group, REMOVEFILTERS('Test Table'[Value]))

However, I am still unable to achieve this. Could anyone please let me know if this is possible please?

Below is the data I am using for this, and a copy of the Waterfall chart;

[v-yueyunzh-msft · Accepted solution]

Hi , @dosania 

For convenience, you can explain whether the data provided in your screenshot is the data that has been calculated and processed to be placed in the waterfall chart or the expected output data that needs to be converted to, and if it is the data that has been processed and placed in the waterfall chart, you can try to refer to this official document to create this chart:

Waterfall charts in Power BI - Power BI | Microsoft Learn

If processing is required, you can provide the logic for your source data and the data transformation you want to achieve.

Best Regards,

Aniya Zhang

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