Comparing Actuals vs Budget with a Waterfall Chart

Question

Hi, I was wondering if it would be possible to help me out quickly. I am trying to compare Actuals vs Budget in a PBI Waterfall Chart but my dimensions does not show "Values". I am only able to see "Category", "Breakdown", "Y Axis", and "Tooltips". Thanks for your help. - Elie&nbsp;&nbsp;REPLY&nbsp;&nbsp;

anonymous · Answer

&nbsp;Hi,&nbsp;&nbsp;Thank you for responding. Please see the screenshots that I uploaded.&nbsp;&nbsp;Thanks,Elie&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

rbk1234 · Answer

Old thread, but an important topic — I noticed it wasn’t addressed.With this visual, which can be installed in Power BI, comparing Budget vs Actual becomes straightforward.&nbsp;&nbsp;&nbsp;

amitchandak · Answer

Can you share sample data and sample output.

anonymous · Answer

HI&nbsp;Anonymous,
In fact, the waterfall chart not suitable to compare between multiple data labels. (normally it used to analyze the breakdown between start and end data label) In my opinion, I'd like to suggest you use matrix visual with measure formula to compare between different data categories.
Regards,
Xiaoxin Sheng

anonymous · Answer

Hi thanks for getting back to me. I posted a picture of a waterfall chart from excel that I would like to recreate. My starting point is my Q1 Actuals and I am creating a bridge to my ending point which is my Budget.

Forum Discussion

Comparing Actuals vs Budget with a Waterfall Chart

6 Replies

Related content

Comparing Actual vs Target Visually

Comparing Quarterly budgets to actual achievement

Waterfall Chart

Waterfall Chart Help

Compare actual vs planned