Percentage growth

[Bisco]

Hello Everyone!

I have an Issue, I'd like to make a chart which the columns are the volume (by month) and the line is the percentual growth comparing the previous period, ex:

	Jan	Fev	Mar
Volume	10	20	30
Percentual Growth	-	100%	50%

Best Regards, Luiz

[v-xjiin-msft]

@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.

[Bisco]

Hello Xi Jin, 

First of all, thank you for answering me!

I have a trouble there, the total of each month is a sum of a lot of rows.

My data is structured like this:

Month	Volume
Jan	5
Jan	2
Jan	3
Feb	1
Feb	2
Feb	4
Feb	3
Feb	10
Mar	15
Mar	15

Do you have any idea to help me?

Best Regards, Luiz

[v-xjiin-msft · Accepted solution]

@Bisco

Then you can do a group by first for your table. Go to Edit Queries -> Group By:

Thanks,
Xi Jin.