Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Hello Everyone,
I need to calculate the percentage change (increase or decrease) over the year for various codes, taking into account that there can be different suppliers for the same code. Additionally, I want to create a line chart displaying the percentage change, with separate lines for each supplier if there are two suppliers.
follow the link.
https://docs.google.com/spreadsheets/d/1KdJng3_lmeIZP69Ppz3EDm4S1Yn3mQZi/edit?usp=drive_link&ouid=11...
Thanks in advance.
Solved! Go to Solution.
Hi Rita,
I have managed to get the result.
Thank you!
Hi @Anonymous
Thank you very much Ritaf1983 for your prompt reply.
If your problem has been solved, please accept it as a solution!
Regards,
Nono Chen
Hi @Anonymous
Can you show the desired result?
Hi Rita,
You can check the expected result now.
Thanks,
Regards,
Rohit Terkar
Where ?
Nothing changed in the attached link:
Hi Rita,
I have managed to get the result.
Thank you!
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 24 | |
| 22 | |
| 21 | |
| 20 | |
| 14 |
| User | Count |
|---|---|
| 59 | |
| 52 | |
| 41 | |
| 33 | |
| 32 |