Urgent help with waterfall chart!

Question

Hi all!I need to build a waterfall that has the following tags as categories (please check 3rd column below) :&nbsp;TAG "GO" =&nbsp;Adjusted EBITDA + Nova RubricaTAG "Net Final Balance" = Cash Generated From Operations +&nbsp;Investment+Net Initial Balance+Others +Income Tax+Net Amortization+Dividends PayableTAG "Gross Debt"= Net Final Balance +&nbsp;Net Debt&nbsp;I am not able to build the graph as the client asked. I am getting the first view, but I would need the second. It's possible? I marked with an X what I would like to eliminate and circled what I needed to show.&nbsp;What I got:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;What I would like (a customer built this on excel and sent to me):&nbsp;&nbsp;Breakdown&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Values (MM) Category&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OrderAdjusted EBITDA14576,31GO1Adjusted EBITDA1312,71GO1Adjusted EBITDA1164,27GO1Adjusted EBITDA-440,39GO1Adjusted EBITDA-1471,32GO1Cash Generated From Operations13919,55Net Final Balance2Cash Generated From Operations1151,61Net Final Balance2Cash Generated From Operations1218,73Net Final Balance2Cash Generated From Operations-592,06Net Final Balance2Cash Generated From Operations-129,75Net Final Balance2Investment-1536,21Net Final Balance2Investment-3598,16Net Final Balance2Net Initial Balance8176,18Net Final Balance2Others-1762,34Net Final Balance2Others352,8Net Final Balance2Others506Net Final Balance2Others-834,27Net Final Balance2Others-676,36Net Final Balance2Others-440,52Net Final Balance2Others-978,69Net Final Balance2Others307,81Net Final Balance2Others146,97Net Final Balance2Others126,5Net Final Balance2Income Tax-1050,56Net Final Balance2Net Amortization0Net Final Balance2Dividends Payable-3495,85Net Final Balance2Net Final Balance10811,39Gross Debt3Gross Debt13199,37Gross Debt3Net Debt2387,98Gross Debt3Nova Rubrica427GO1&nbsp;

v-lid-msft · Answer

Hi&nbsp;Anonymous ,
&nbsp;
We can try to add a sort column to meet your requirement:
&nbsp;

&nbsp;
Best regards,
&nbsp;

v-lid-msft · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?
Best regards,

Forum Discussion

Urgent help with waterfall chart!

2 Replies

Related content

Waterfall Chart

Waterfall Chart Help

Waterfall Charts with running totals

Stacked Waterfall Chart

Power Bi Waterfall chart question

Adjusted EBITDA	14576,31	GO	1
Adjusted EBITDA	1312,71	GO	1
Adjusted EBITDA	1164,27	GO	1
Adjusted EBITDA	-440,39	GO	1
Adjusted EBITDA	-1471,32	GO	1
Cash Generated From Operations	13919,55	Net Final Balance	2
Cash Generated From Operations	1151,61	Net Final Balance	2
Cash Generated From Operations	1218,73	Net Final Balance	2
Cash Generated From Operations	-592,06	Net Final Balance	2
Cash Generated From Operations	-129,75	Net Final Balance	2
Investment	-1536,21	Net Final Balance	2
Investment	-3598,16	Net Final Balance	2
Net Initial Balance	8176,18	Net Final Balance	2
Others	-1762,34	Net Final Balance	2
Others	352,8	Net Final Balance	2
Others	506	Net Final Balance	2
Others	-834,27	Net Final Balance	2
Others	-676,36	Net Final Balance	2
Others	-440,52	Net Final Balance	2
Others	-978,69	Net Final Balance	2
Others	307,81	Net Final Balance	2
Others	146,97	Net Final Balance	2
Others	126,5	Net Final Balance	2
Income Tax	-1050,56	Net Final Balance	2
Net Amortization	0	Net Final Balance	2
Dividends Payable	-3495,85	Net Final Balance	2
Net Final Balance	10811,39	Gross Debt	3
Gross Debt	13199,37	Gross Debt	3
Net Debt	2387,98	Gross Debt	3
Nova Rubrica	427	GO	1