Forum Discussion

Regular Visitor

2 years ago

Difficulty pulling data onto Line Chart

Hi everyone, I have a Power BI dashboard that pulls data from a csv file. I refreshed the data this past Monday. I have a card showing the total backlog#. Right now, the line chart is not pulling co...

Super User

2 years ago

Can you provide some sample data or pbix file?

krnfds
Regular Visitor
2 years ago
Unfortunately, I cannot provide the whole file 😞
The backlog qty column looks like this where it shows a specific order. The cell is blank if it is not backlogged.
The x axis of the line chart uses this dax expression:
Backlog Qty. = COUNT ( 'PPIOO000_P34'[Backlog Qty] ) + 0
The y axis uses this:
Backlog Calendar =
VAR StartDate = DATE(2021, 1, 1)
VAR EndDate = DATE(2024, 12, 31)
VAR DateRange = ADDCOLUMNS(
CALENDAR(StartDate, EndDate),
"WeekDay", WEEKDAY([Date], 2)
)
RETURN
FILTER(
DateRange,
[WeekDay] = 1
)

Please let me know if you need additional info or have other questions!
- xifeng_L
  Super User
  2 years ago
  I think you should change the table structure to the following, keeping a snapshot on each Monday.
  
  Day Backlog Qty
  4/1/2024
  xxxxx
  xxxxx
  xxxxx
  4/2/2024
  xxxxx
  xxxxx
  xxxxx
  4/3/2024
  xxxxx
  xxxxx
  xxxxx
  ...
  ...
  
  Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !
  
  Thank you~
  - krnfds
    Regular Visitor
    2 years ago
    Sorry, I don't fully understand. How would I keep a snapshot automatically?
    Are you saying I should change my date table to show every day?
    This is what my date table looks like where it spans all the way to the end of 2024.

Related content