Forum Discussion

RuudVanTongeren's avatar
RuudVanTongeren
New Member
3 years ago

Waterfall starting with 0-value each year

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?

Show and Tell

2 Replies

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    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.

  • RuudVanTongeren's avatar
    RuudVanTongeren
    New Member
    3 years ago

    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