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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
lmh100
New Member

Waterfall chart help

Hi all,

 

New to PowerBI - trying to recreate some charts I am use to in excel.

 

Its a property business - which has a list of tenants - with rent adding up to a total rent roll - across different sites

 

I want to bridge total rent roll at the end of one period (2017 in this example) to the next - end of 2018

 

The bridge segments - i would like to come from the 2nd table - split between new tenants starting, tenants leaving and tenants renewing

 

The first table:

 

 

Property codeDateClosing rent roll
10131/12/2017                      1,000
10131/12/2018                      1,200
10231/12/2017                      2,000
10231/12/2018                      2,500

 

The 2nd table:

 

 

Property codeDateNet RRStatus
10131/03/2018500New starters
10131/03/2018-500Leavers
10131/03/2018200Renewals
10231/03/2018500New starters
10231/03/2018-500Leavers
10231/03/2018500Renewals

 

As you can see the sum of the movements - equals the total movement in rent roll

 

IN power BI - i have got as far as producing the table below

 

pbi table.png

 

And I would like the graph to look like  - something like the below

 

bridge.png

 

so its 3000 + 1000 new rev.- 1000 rev. + 700 incremental rev. from existing = 3700 rent roll

 

Any help would be greatly apprecaited

 

thanks,

 

Laurence

 

1 REPLY 1
v-chuncz-msft
Community Support
Community Support

@lmh100,

 

You may try using UNION Function to add a calculated table first.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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