Forum Discussion

revansh's avatar
revansh
Icon for Helper IV rankHelper IV
8 years ago
Solved

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

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
      revansh
      Icon for Helper IV rankHelper IV
      8 years ago

      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