- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I should have a value for every week
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, @LFM
create new column using below dax
weeknumber =
weeknum(ypurtablename[datecolumn])
and put that column in X- axis
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Proud to be a Super User! | |
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
05-29-2024 12:58 PM | |||
11-07-2024 11:54 AM | |||
03-12-2024 11:03 AM | |||
08-27-2024 03:16 PM | |||
06-25-2024 09:52 AM |
User | Count |
---|---|
127 | |
81 | |
59 | |
59 | |
44 |
User | Count |
---|---|
182 | |
114 | |
82 | |
67 | |
52 |