Forum Discussion

Kopek's avatar
Kopek
Helper IV
7 years ago
Solved

Waterfall chart issue

Hi Everyone!   I wouldlike to create waterfall chart, but with quite different data. Please find screenshot below - this chart was done in the excel and I would like to move it to powerBi, but I a...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Monica,

     

    According to my test, the breakdown in the Power BI Waterfall chart exists in all milestones. Please check out the demo in the attachment. So the data could be like below. 

    Name       Category      Value

    m1 start 10
    m2 start 10
    m2 Category 2 -2.13
    m3 start 10
    m3 Category 2 -2.13
    m3 Category 3 0.6
    m3 Category 4 0.2
    m4 start 10
    m4 Category 2 -2.13
    m4 Category 3 0.6
    m4 Category 4 0.2
    m4 Category 8 3.6

    waterfall

     

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Monica,

 

According to my test, the breakdown in the Power BI Waterfall chart exists in all milestones. Please check out the demo in the attachment. So the data could be like below. 

Name       Category      Value

m1 start 10
m2 start 10
m2 Category 2 -2.13
m3 start 10
m3 Category 2 -2.13
m3 Category 3 0.6
m3 Category 4 0.2
m4 start 10
m4 Category 2 -2.13
m4 Category 3 0.6
m4 Category 4 0.2
m4 Category 8 3.6

waterfall

 

 

Best Regards,

Dale

Kopek's avatar
Kopek
Helper IV
7 years ago

@v-jiascu-msft  Hi Dale,

 

I think I understood how waterfall charts works, and it simply won't work for our needs.

We'd rather use one of bar chart.

But anyway, I am very grateful for your help. 

Thanks a lot!

Monika