Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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?
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
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.
User | Count |
---|---|
143 | |
71 | |
69 | |
53 | |
52 |
User | Count |
---|---|
208 | |
94 | |
64 | |
60 | |
57 |