Waterfall starting with 0-value each year

[RuudVanTongeren]

I want to create a waterfall for several years with a breakdown for each month. That works fine but to compare the years it should be great if I can start each year on zero. Now I have a total for each year but the years starts with the total of the last year which means the totals become bigger en bigger. That's why I want to start each year with 0.

Does anyone know if this is possible and how I can realize that?

[RuudVanTongeren]

Hi thanks for your reply, but that is not what I mean. I created an example in Excel and as you can see I have a waterfall for each month of the year and at the end I have the total of the year. Next year I want to start in January with zeroExample in Excel. The Waterfall I try to realize in PBI

[v-yanjiang-msft]

Hi @RuudVanTongeren ,

According to your description, if you mean the value starts on zero, you can find it is if you turn on the data labels.

Here's my sample data:

Or if you still want to show the value subtract value of previous year, create a measure like this:

Measure =
MAX ( 'Table'[Value] )
    - MAXX (
        FILTER ( ALL ( 'Table' ), 'Table'[Year] = MAX ( 'Table'[Year] ) - 1 ),
        'Table'[Value]
    )

Result:

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

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