Forum Discussion
LFM
Helper III
Helper IIII 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...
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
LFMHelper III
Helper IIII should have a value for every week
Idrissshatila
Super User
Super UserHello 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