Forum Discussion

alecw044's avatar
alecw044
Regular Visitor
8 years ago
Solved

Waterfall Chart Not Showing Decreases

Hello,   I am trying to create a waterfall chart which would show the increases/decreases from a value from month to month. Currently, I can only get it to where it is adding the values from the pr...
Tips and Tricks
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi alecw044,

     

    You should drag an other field to Breakdown so that it will show the Decrease. 

     

    In addition, you could calculate the difference for the Count of Assets and create the waterfall chart.

     

    difference =
    CALCULATE (
     MAX ( 'Table1'[Count] ),
     FILTER ( ALL ( 'Table1' ), 'Table1'[Month] = EARLIER ( Table1[Month] ) + 1 )
    )
     - 'Table1'[Count]

     

     

    More details, you could have a look at this document.

     

     

    If you still need help, please share some data sample and your expected output.

     

    Best  Regards,

    Cherry

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi alecw044,

 

You should drag an other field to Breakdown so that it will show the Decrease. 

 

In addition, you could calculate the difference for the Count of Assets and create the waterfall chart.

 

difference =
CALCULATE (
 MAX ( 'Table1'[Count] ),
 FILTER ( ALL ( 'Table1' ), 'Table1'[Month] = EARLIER ( Table1[Month] ) + 1 )
)
 - 'Table1'[Count]

 

 

More details, you could have a look at this document.

 

 

If you still need help, please share some data sample and your expected output.

 

Best  Regards,

Cherry

Black_magic100's avatar
Black_magic100
Helper III
7 years ago

Hey I am trying to achieve exactly this, but how would I incorpoirate my date table?  Whenever I try and use the date column after the EARLIER function I just get red squiggly lines and I have no idea why