Forum Discussion

LFM's avatar
LFM
Icon for Helper III rankHelper III
2 years ago
Solved

I need help with something very simple

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...
General Comment
Need Help
Show and Tell
Tutorial Requests
  • Dangar332's avatar
    Dangar332
    2 years ago

    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

LFM's avatar
LFM
Icon for Helper III rankHelper III
2 years ago

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's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

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