Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
RuudVanTongeren
New Member

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?

2 REPLIES 2
RuudVanTongeren
New Member

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 PBIExample in Excel. The Waterfall I try to realize in PBI

v-yanjiang-msft
Community Support
Community Support

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:

vyanjiangmsft_0-1692344590815.png

vyanjiangmsft_1-1692344723065.png

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:

vyanjiangmsft_2-1692344936770.png

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.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.