Help with simple Line Graph

[David_F64]

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

Year	YTD July	YTD August	YTD September	YTD October	YTD November	YTD December	YTD January	YTD February	YTD March	YTD April	YTD May	YTD June
2019	90778	181793	260838	344859	439550	510995	581320	666322	758179	836571	931289	1006200
2020	83389	166121	246566	335286	416313	490190	568448	649631	722567	812681	913323	1004026
2021	94833	195960	298034	379797	480347	568283	641808	730416	838297	940195	1055169	1164658
2022	114233	225107	347072	447860	570731	689867	782427	913441	1052326	1168016	1323358	1477256
2023	145179	302414	380051	380051	380051	380051	380051	380051	380051	380051	380051	380051

 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

[ryan_mayu · Accepted solution]

@David_F64 

select year column and unpivot other columns in PQ

Unpivot columns (Power Query) (microsoft.com)

then you can draw line graph. 

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