Waterfal Chart -HELP

[revansh]

Hi,

I want to plot a waterfall chart comparing ACTUAL and TARGETs values.

Actual Hours = 160

Target Hours = 100

Support = 40

OT = 20

I want to plant a waterfall chart with 4 bars in waterfall chart.

first bar = target hours = 100

second bar = support = 40

third bar= OT = 20

fourth bar = Actual = 160

can i achive this in powerbi.

I dont have any date dimension to add in X-aixs.

Thanks

[v-yuezhe-msft · Accepted solution]

@revansh,

What is your table structure? It doesn't matter that you don't have date dimension to add in X-Axis,  as long as the sequence of X-Axis has a meaning. There is an example for your reference.


Regards,

Lydia

[revansh]

Hi Lydia,

Thanks for the reply.

1. Is there any way, we can set the starting column color same as "ACtual" column color.

2. Add a third column(sum of Actual and OT) in your example which start at 0 on X-axis?

Thanks in Advance