Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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.
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