The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
Hi @sanjanarama ,
Please kindly refer to the solution in the following post:
Waterfall Chart using multiple measures - Microsoft Power BI Community
Best Regards,
ShundaSteph
@Anonymous
I have tried the same, how to make the marked ones to start from zero?
@Anonymous
Can we have it presenting like below image