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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
123abc
Community Champion
Community Champion

Line Chart based on Given Data Power bi Desktop

Dear Experts,

 

Below is the excel version, I try to develop this type of line charts on BI Desktop based on below data but cant be succeeded, please kindly guide me how to do this. I try my bast and many attempts but can't succeeded. Thank You.

 

Chart Required.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Data.jpg

 

1 ACCEPTED SOLUTION
Dhairya
Super User
Super User

First open Power query editor >> click trandform tab >> select year column >> click on "Unpivot other columns".
then click on close and apply, Now in power BI desktop plot line visuals and put months on X-axis, facts value on Y-axis and year in legends.

Please mark my solution as accepted if it works for you.

View solution in original post

1 REPLY 1
Dhairya
Super User
Super User

First open Power query editor >> click trandform tab >> select year column >> click on "Unpivot other columns".
then click on close and apply, Now in power BI desktop plot line visuals and put months on X-axis, facts value on Y-axis and year in legends.

Please mark my solution as accepted if it works for you.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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