Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Rohit_terkar
Frequent Visitor

Percentage

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.

2 REPLIES 2
v-fenling-msft
Community Support
Community Support

Hi, @Rohit_terkar 

May I ask if you have gotten this issue resolved? If it is solved, please share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.


If it is not resolved, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file.

 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

VijayP
Super User
Super User

@Rohit_terkar 

 

If somebody wants their question to be answer fast , it is always suggested the sample data + what they have already tried to get the answer but failed. It helps us to understand the problem statement correctly.

Just adding sample data ( for your information, one need to request access once they click on the link provided, which is bit unfriendly, since you are requesting help) ! 




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.