Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Waterfall Chart summing issue

Hi all,

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

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

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.

 

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

 

Need Help

4 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    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]
)

     

    Best regards,

    Yuliana Gu

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

         

        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

  • poweraspirant's avatar
    poweraspirant
    New Member
    5 years ago

    Hi Everyone, 

    I am trying to develop a Waterfall chart on the data attached. But unable to get correct balance amount . Can anyone help me how to declare start value and get correct balance in waterfall chart.