Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have a data with multiple products, year, month and the values.
I want to plot the line graph showing the % growth of value from Jan to Feb for each year and product as a filter Can you help with code or the measure I need to use for the graph.
Solved! Go to Solution.
Hi @bvsaicharitha,
Do you want to get the %change like below?
If you want to get the %change above, you could refer to the measures below.
Jan = CALCULATE(SUM(Table1[Sales]),FILTER('Table1','Table1'[Month number]=1&&'Table1'[Year]=MAX('Table1'[Year]))) Feb = CALCULATE(SUM(Table1[Sales]),FILTER('Table1','Table1'[Month number]=2&&'Table1'[Year]=MAX('Table1'[Year]))) %change = DIVIDE([Feb]-[Jan],[Jan])
If you need additional help, please share the output you desired.
In addition, you could have a reference of Measures – Month to Month Percent Change.
Best Regards,
Cherry
Hi @bvsaicharitha,
Do you want to get the %change like below?
If you want to get the %change above, you could refer to the measures below.
Jan = CALCULATE(SUM(Table1[Sales]),FILTER('Table1','Table1'[Month number]=1&&'Table1'[Year]=MAX('Table1'[Year]))) Feb = CALCULATE(SUM(Table1[Sales]),FILTER('Table1','Table1'[Month number]=2&&'Table1'[Year]=MAX('Table1'[Year]))) %change = DIVIDE([Feb]-[Jan],[Jan])
If you need additional help, please share the output you desired.
In addition, you could have a reference of Measures – Month to Month Percent Change.
Best Regards,
Cherry
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |