Forum Discussion
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 code | Date | Closing rent roll |
| 101 | 31/12/2017 | 1,000 |
| 101 | 31/12/2018 | 1,200 |
| 102 | 31/12/2017 | 2,000 |
| 102 | 31/12/2018 | 2,500 |
The 2nd table:
| Property code | Date | Net RR | Status |
| 101 | 31/03/2018 | 500 | New starters |
| 101 | 31/03/2018 | -500 | Leavers |
| 101 | 31/03/2018 | 200 | Renewals |
| 102 | 31/03/2018 | 500 | New starters |
| 102 | 31/03/2018 | -500 | Leavers |
| 102 | 31/03/2018 | 500 | Renewals |
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
And I would like the graph to look like - something like the below
so its 3000 + 1000 new rev.- 1000 rev. + 700 incremental rev. from existing = 3700 rent roll
Any help would be greatly apprecaited
thanks,
Laurence
