cancel
Showing results for
Did you mean:
Helper IV

## Waterfal Chart -HELP

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

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator

## Re: Waterfal Chart -HELP

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Moderator

## Re: Waterfal Chart -HELP

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IV

## Re: Waterfal Chart -HELP

Hi Lydia,

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?

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors