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.

    • goyasor's avatar
      goyasor
      Frequent Visitor
      9 years ago

      Thanks for your response. Unfortunately that didn't work for me.

       

      I'm getting a constant figure in the Periods column:

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User
        9 years ago

        Be aware that this is a measure an not a calculated column that I use to show the percentages.

         

        If you can share some data I can try to simulate and redefine the formula.

         

        MFelix