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.
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
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors