Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Waterfall chart- showing +/- difference.

Hi All,


I'm new to the world of DAX and Power BI and am really interested in creating a Waterfall chart to show the year on year difference between customer applications. I stumbled across a solution myself yesterday, and I managed to create a great looking waterfall exactly how I needed it. Unhelpfully, Power BI crashed and I lost the measure (autosave function anyone?!). I tried all night to replicate what I did but I just can't work it out now Smiley Sad. I'm certain there is something fundamental and easy that I am missing and I wonder if you helpful lot could help me out?




I want to count the number of 'customer application ID's' I have in a table for each year and display the+/- difference between each year in a waterfall chart. Each customer has a year of application stored against them.


I have been playing around with the following formula to no avail:


=CALCULATE(COUNT('Customer'[Customer Application Form ID)-CALCULATE(COUNT('Customer'[Customer Application Form ID), PREVIOUSYEAR ('Customer'[Application Year])))


I might have even created a date table yesterday but I honestly tried so many things I can't now remember how I managed it.


The formula above happily counts the total number of customer application ID's for each year and shows this total figure in the waterfall chart. What I'm actually after is the difference between years i.e whether the number was +/- the previous year's figure.


I'd really appreciate it if you could spare a few minutes to walk me through the process.


Thanks so much for any help you can offer!



Helpful resources

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors