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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.