Obtain one histogram bar from a waterfall chart

[andvpp]

Hello,

I am a new Power BI user and I am struggling to create a histogram with cumulative sums inside the bars. 

I have seen that the Waterfall charts do this very nicely, adding the values of certain briques to reach a specific number.
But I haven't been able to translate this information into a single bar. Is it possible? 

You see on the left that I can see the "detail" of my sum reaching the good final value of 4. Nevertheless, on the right, when I use stacked bars, the values are added independently and reaches a much larger value. 

 If anybody has a suggestion on how to specify that it is a cumulative sum, I would really appreciate it. 

Thank you,

Andrea

[v-haibl-msft]

@andvpp

You need to add an index column in Query Editor and then create a measure to get the cumulative sum result. Uploaded my PBIX file here for reference. You can also take a look at this article to understand more about how to get Cumulative Total.

Cumulative = 
CALCULATE (
    SUM ( Table1[Values] ),
    FILTER ( ALL ( Table1 ), Table1[Index] <= MAX ( Table1[Index] ) )
)

Best Regards,

Herbert

[andvpp]

Herbert,

Thank you very much for taking a look at my post and replying!

I still have one question though, maybe you can help me with this too.

If you see the image I posted, on the right there is a Bar with Stacked Values.

Is there a way to create a column or something to use as a color filter so that my graph looks like that?

Ideally, the bar starts at -10, finishes at 4 as the cumulative sum, and has a color filter showing the Briques that are being added.

Have a nice day!

Andrea

[v-haibl-msft]

@andvpp

You only need to add Birques to Legend as below. But there will be a little difference, the column bar will start from the biggest negative number -2 but not -10.

Best Regards,

Herbert