Forum Discussion
Waterfall variation by sales type
Hi,
I'm trying to create a waterfall that shows:
First Bar: 2015 total
Middle Bars: Year over Year Change
End Bar: 2016 Total
For example:
First Bar: 2015 total = 20M Cars
Middle Bars: GM+400K, Ford -100K, Toyota-200K, Honda+500K, Chrysler+400K
End Bar: 2016 total = 21M Cars
I'm having trouble creating this. Does anyone know how I could achieve what I'm after?
Many thanks.
10 Replies
v-yulgu-msftMicrosoft Employee
Hi goyasor,
By default, the waterfall chart can only show total value at the end bar, this value is calculated automatically.
Please post some sample data in table view , and if poossible post an image to describe your desired output so that I can try some workarounds to see whether your requirement can be achieved.
Best regards,
Yuliana GuThank you for your response. Here's a picture of what I've trying to achieve in Power BI. As you can see, it's possible in Excel with some data manipulation:
Essentially, I want the first column to be 2015 total and the last column to be 2016 total. The columns in-between should be the variance by category.
I can't find a way of implementing this Power BI. I hope you guys can help.
Thank you for your response. Here's a picture of what I've trying to achieve in Power BI. As you can see, it's possible in Excel with some data manipulation:
Essentially, I want the first column to be 2015 total and the last column to be 2016 total. The columns in-between should be the variance by category.
I can't find a way of implementing this Power BI. I hope you guys can help.
Thank you for your response. Here's a picture of what I've trying to achieve in Power BI. As you can see, it's possible in Excel with some data manipulation:
Essentially, I want the first column to be 2015 total and the last column to be 2016 total. The columns in-between should be the variance by category.
I can't find a way of implementing this Power BI. I hope you guys can help.
