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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
David_F64
Frequent Visitor

Help with simple Line Graph

New to Power BI (Accountin, excel and sql background) and I have created a dashboard with various visulisations that work fine, however I am trying to add what I think should be a very simple line graph (at least its very simple in Excel) and am getting no where

So my Data looks like

YearYTD JulyYTD AugustYTD SeptemberYTD OctoberYTD NovemberYTD DecemberYTD JanuaryYTD FebruaryYTD MarchYTD AprilYTD MayYTD June
2019907781817932608383448594395505109955813206663227581798365719312891006200
2020833891661212465663352864163134901905684486496317225678126819133231004026
20219483319596029803437979748034756828364180873041683829794019510551691164658
20221142332251073470724478605707316898677824279134411052326116801613233581477256
2023145179302414380051380051380051380051380051380051380051380051380051380051

 and I just want a line graph one line per year. As I said, simple in Excel (even the recommended Chart gets it right without needing to juggle anything)

 

The data comes from a view I created on the database, so if I need to change the format I can

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@David_F64 

select year column and unpivot other columns in PQ

Unpivot columns (Power Query) (microsoft.com)

then you can draw line graph. 

1.PNG

 

you can sort by another column to rearrange the month orders.

Sort one column by another column in Power BI - Power BI | Microsoft Learn

 

pls see the attachment below





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
ryan_mayu
Super User
Super User

@David_F64 

select year column and unpivot other columns in PQ

Unpivot columns (Power Query) (microsoft.com)

then you can draw line graph. 

1.PNG

 

you can sort by another column to rearrange the month orders.

Sort one column by another column in Power BI - Power BI | Microsoft Learn

 

pls see the attachment below





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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