Forum Discussion
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...
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~
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.