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 make sense.

  • 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

8 Replies

    • LFM's avatar
      LFM
      Icon for Helper III rankHelper III

      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.