Percentage growth

Bisco

Was your source table just the same as the shared sample data? If so, to achieve your requirement. You can refer to following steps. If not, please share us your source table structure.

1. Go to Edit Queries - > Transform menu - > Unpivot your table and go to Add Column menu - > add an new index column for it:

2. Close & Apply, create a new calculated column to calculate the Percentual Growth. The expression is like:

percentual growth =
IF (
    LOOKUPVALUE ( Table1[Volume], Table1[Index], Table1[Index] - 1 )
        = BLANK (),
    0,
    (
        Table1[Volume]
            - LOOKUPVALUE ( Table1[Volume], Table1[Index], Table1[Index] - 1 )
    )
        / LOOKUPVALUE ( Table1[Volume], Table1[Index], Table1[Index] - 1 )
)

3. Then create the Line and stacked column chart, put Volume in Column values of chart and Percentual Growth in Line values. Result shows like this:

Thanks,
Xi Jin.