I need help with something very simple

[LFM]

Hello. Im new to power bi and need helt with something very basic. I want to make a line chart where price follows the year like in the power query table. Somehow it not working and the charts doesnt make sense.

 

 

[Dangar332]

Hi, @LFM 

put price column in Y- axis

[LFM]

Yes, thats what I did in the second chart. Its just showing a straight line somehow. When i use barchart f.eks. it shows the values "2" for 2022 and "50" for 2023.

[Dangar332]

Hi, @LFM 

attach your screenshort 

[LFM]

 I should have a value for every week

[Dangar332]

Hi, @LFM 

create new column using below dax

weeknumber =
 weeknum(ypurtablename[datecolumn])

and put that column in X- axis

[LFM]

Thanks for your help, but still there are something wrong with the values in the charts. I dont know why every week have the same value. 

 

[Dangar332 · Accepted solution]

HI, @LFM 

try to make new column in your old table (weekly Prices) which has column date1 and price column and then put new column(week column) in X- axis and Price In Y - axis 

and make sure sum of price instead count of price in Y- axis

or 

make sure your new table(Weeklyprices) is connected with (Weekly prices) with common column like date

[Idrissshatila]

Hello @LFM ,

you're seeing the data per year, you need to create a week dimension field and attack it.

check this https://www.youtube.com/watch?v=BirVo-FsekE