Forum Discussion
Need To implement the Waterfall chart according to Below Image
Suppose I have a table of P&L data which is mentioned below
| P&L | $ USD |
| Sales | 10000 |
| COGS | -5000 |
| Gross Income | 5000 |
| SG&A | -2000 |
| Depreciation | -1000 |
| Other Inc. | 500 |
| EBIT | 2500 |
| Interest | -400 |
| Tax | -300 |
| Net Income | 1800 |
Need to implement the Waterfall chart exactly like the below image with the P&L data
Unable to plot it .kindly help thanks in advance
5 Replies
Suppose I have a table of P&L data which is mentioned below
P&L $ USD Sales 10000 COGS -5000 Gross Income 5000 SG&A -2000 Depreciation -1000 Other Inc. 500 EBIT 2500 Interest -400 Tax -300 Net Income 1800
Need to implement the Waterfall chart exactly like the below image with the P&L data
Unable to plot it .kindly help thanks in advanceHi Anonymous
Based on my research, Power BI's waterfall chart visual does not achieve an exact match to your image.
According to your data, the waterfall chart effect in Power BI is as follows:Click “Transform data” to enter “Power Query”, select “Add Column” -> “Index Column” to create an index column.
Select the P&L column and choose Sort by Index column.
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-sdhruvCommunity Support
Hi Anonymous ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You- v-sdhruv
Hi @sourav_ThePBI_G ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You - v-sdhruv
Hi @sourav_ThePBI_G ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You