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