Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Power BI Waterfall Breakdown. Need help. Urgent!

Hi,

 

I have this data:

 

SalesValueReason for diff
Actual Sales500 
 75Price
 75Volume
 25TP
 25MIX
Budget700 

 

As shown. The difference between Budget and Actruals is 200, which is the total of Price, Volume, TP and Mix.

 

I want to make a waterfall like this:

 

 

I try to "Reason for diff" into "Breakdown", but it dont work. 

 

Can someone please tell how this is done in Power BI?

 

Thanks, and have a nice day :)

Need Help

2 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    Hi Anonymous ,

     

    By my tests and research, I'm afraid that we may not achieve your desired output based on your data sample in Power BI currently.

     

    We only could get the output below with Waterfall chart.

     

     

    Best  Regards,

    Cherry

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago
      Hi Cherry, Thanks for your answer! I know. But thats too messy i think. It have to be as clean as possible, as I shown in my picture. Are you sure that there is no soultion for this? Maybe some settings or another setup for the data? I have tried many ways now without luck.