Forum Discussion

goyasor's avatar
goyasor
Frequent Visitor
9 years ago

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 B...
Need Help
Tips and Tricks
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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 Gu

goyasor's avatar
goyasor
Frequent Visitor
9 years ago

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.