cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Waterfall Chart summing issue

Hi all,

I have some data, this is a part of it:

Screen Waterfall 1.PNG

I want to do the Waterfall Chart which shows me difference between sums along every version, the table of version/value looks like this:

Screen Waterfall 2.PNG

but when I try to do the version/value waterfall chart it adds up to total  1 567 367,89 and I want it to show me changes between f.e. W13 and W14 is +47,11 not +170 055,70.

Screen Waterfall 3.PNG

 

How do I do that? Should I do some measures? I want it to be responsive to other filters also so I cant do new table with flat values.

Thanks in advance

 

3 REPLIES 3
Highlighted
Microsoft
Microsoft

Re: Waterfall Chart summing issue

Hi @Anonymous,

 

Please add below calculated columns in original table.

Sum per version =
CALCULATE (
    SUM ( Version_Value[Value] ),
    ALLEXCEPT ( Version_Value, Version_Value[Version] )
)

Sum next version =
CALCULATE (
    SUM ( Version_Value[Value] ),
    FILTER (
        Version_Value,
        Version_Value[Index]
            = EARLIER ( Version_Value[Index] ) + 1
    )
)

Diff =
IF (
    Version_Value[Sum next version] = BLANK (),
    Version_Value[Sum per version],
    Version_Value[Sum next version] - Version_Value[Sum per version]
)

1.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Anonymous
Not applicable

Re: Waterfall Chart summing issue

I did what you told and it looks good, but I can't filter the data now, f.e. i want to show only for January, but it still sums all the cells.

Is there a way to enable this kind of filters?

 

Radkos

Highlighted
Anonymous
Not applicable

Re: Waterfall Chart summing issue

Screen_Waterfall 4.PNG 

These columns are very important to filter, do I put something into existing measure or should I write new one?

Thank again for all help.

Radkos

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors