Forum Discussion

krnfds's avatar
krnfds
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...
Need Help
xifeng_L's avatar
xifeng_L
Super User
2 years ago

Can you provide some sample data or pbix file?

krnfds's avatar
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's avatar
    xifeng_L
    Super User
    2 years ago

    I think you should change the table structure to the following, keeping a snapshot on each Monday.

     

    DayBacklog 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's avatar
      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. 

       

    • krnfds's avatar
      krnfds
      Regular Visitor
      2 years ago

      I added these columns to the main table. Would these help in any way?

      Total Backlog Qty =
      COUNT(PPIOO000_P34[Backlog Qty])
       
      Refresh Date and Weekday Name is using Power Query, so it would pull new info automatically when the data refreshed.