Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 correctly where the quantity each week amounts to the total backlog#.
Instead, I want the chart to show what the total backlog# was for each Monday if that makes sense. I have a date table showing every date which is a Monday. The backlog quantity is pulled from a different table, capturing the count of rows with values in them in the Backlog Qty. column.
If I were to make this dashboard refresh everyday on the service, what would I need to do to make the line chart take the total backlog# only on Mondays, and save it so that it can be referenced for previous Mondays?
Please let me know if you have any questions if it does not make sense! Thank you so much!
This is what the graph looks like right now which is wrong. Each Monday should actually be showing a number ranging from 600-900 each week where it does not sum to the current backlog number of 882.
Can you provide some sample data or pbix file?
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:
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?
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.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
23 | |
11 | |
10 | |
9 | |
8 |