Reply
LFM
Helper II
Helper II
Partially syndicated - Outbound

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.

Power query.png

year price chart.png

1 ACCEPTED SOLUTION

Syndicated - Outbound

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

View solution in original post

8 REPLIES 8
Dangar332
Super User
Super User

Syndicated - Outbound

Hi, @LFM 

put price column in Y- axis

Syndicated - Outbound

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.

Syndicated - Outbound

Hi, @LFM 

attach your screenshort 

Syndicated - Outbound

Barchat date price.png

 I should have a value for every week

Syndicated - Outbound

Hi, @LFM 

create new column using below dax

weeknumber =
 weeknum(ypurtablename[datecolumn])

 

and put that column in X- axis

 

Syndicated - Outbound

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. 

 

Weeknumber price.png

Syndicated - Outbound

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

Syndicated - Outbound

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

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)