Forum Discussion
sanjanarama
Resolver I
Resolver Iwaterfall chart with multiple breakdown and order
Can anyone help in building up right price waterfall chart? my data is as below and how waterfall should look like is mentioned with same order. I tried all ways online but unable to achive this chart?
| Quarter----- | customer---- | family | description--- | Invoice price----- | RPU---------- | NetPrice------- | Cost----- | Margin----- |
| 2021Q4 | New Info | Family one | 1234 | 160.00 | -4.33333 | 155.6667 | 8 | 150.6667 |
| 2021Q4 | New Info | Family one | 1234 | 164.00 | -10 | 154 | 10 | 134 |
| 2022Q1 | New Info | Family one | 1234 | 160.00 | -9 | 151 | 35 | 111 |
| 2022Q1 | New Info | Family one | 1234 | 164.00 | -58.0467 | 105.9533 | 42 | 100.9533 |
| 2022Q2 | New Info | Family one | 1234 | 160.00 | -8.62993 | 151.3701 | 18 | 151.3701 |
| 2022Q2 | New Info | Family one | 1234 | 164.00 | -5.97458 | 158.0254 | 14 | 100.0254 |
3 Replies
Hi sanjanarama ,
Please kindly refer to the solution in the following post:
Waterfall Chart using multiple measures - Microsoft Power BI Community
Best Regards,
ShundaSteph
sanjanaramaAnonymous
I have tried the same, how to make the marked ones to start from zero?- sanjanarama
Anonymous
Can we have it presenting like below image
