P&L Waterfall

[NikiTiki]

Community hi,

Did someone create P&L Waterfall?

I have measures (It's simple calculation):
Total income
COGS
Gross profit
Expenses1
Expenses2
Expenses3
Expenses4
Expenses5
Net operating income

I want to display this in a waterfall
Example of my data:

Period	Metrics	Value
2021-01	Total Revenue	5 000 000,00
2021-01	COGS	450 000,00
2021-01	Gross Profit	4 550 000,00
2021-01	Ex1	300 000,00
2021-01	Ex2	200 000,00
2021-01	Ex3	150 000,00
2021-01	Ex4	200 000,00
2021-01	Ex5	400 000,00
2021-01	Net Operating Profit	3 300 000,00
2021-02	Total Revenue	8 000 000,00
2021-02	COGS	480 000,00
2021-02	Gross Profit	7 520 000,00
2021-02	Ex1	400 000,00
2021-02	Ex2	200 000,00
2021-02	Ex3	250 000,00
2021-02	Ex4	200 000,00
2021-02	Ex5	400 000,00
2021-02	Net Operating Profit	6 070 000,00
2021-03	Total Revenue	4 500 000,00
2021-03	COGS	450 000,00
2021-03	Gross Profit	4 050 000,00
2021-03	Ex1	100 000,00
2021-03	Ex2	200 000,00
2021-03	Ex3	150 000,00
2021-03	Ex4	200 000,00
2021-03	Ex5	200 000,00
2021-03	Net Operating Profit	3 200 000,00
2021-04	Total Revenue	5 000 000,00
2021-04	COGS	250 000,00
2021-04	Gross Profit	4 750 000,00
2021-04	Ex1	300 000,00
2021-04	Ex2	200 000,00
2021-04	Ex3	250 000,00
2021-04	Ex4	200 000,00
2021-04	Ex5	400 000,00
2021-04	Net Operating Profit	3 400 000,00

[sturlaws · Accepted solution]

Hi,

you can achieve it by using a custom visual. You should also add a metric-dimension with a column on how the metrics should be sorted:
pbix

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.