Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Need help trying to figure out how to get inventory levels by day in Power BI with direct query connection(cannot use calculated tables as it does not refresh once published to the service).
the way the data is kept is inventory starts at the beginning of the month and then adds subtracts on a daily basis.
here is a sample of how it looks:
Date **** StockQty
02/04/24 **** 50
02/04/24 **** -30
02/03/24 **** 30
02/03/24 **** -45
02/02/24 **** 45
02/02/24 **** -20
02/01/24 **** 20
01/31/24 **** 30
01/31/24 **** -25
01/30/24 **** 25
01/30/24 **** -50
01/29/24 **** 50
01/29/24 **** -45
the purpose is to add the result to a chart and see the changes by day.
Hi, @Chanti
If you want to show the change from day to day, a line chart or bar chart can show this change, or you can use @lbendlin suggestion to consider a waterfall chart, or you can look in Power BI visual to find the visual that suits your needs.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Yes.
The issue is not the charts, the issue is the formula that can take into consideration that the data keeps beginning open inventory and closing ending inventory by day except for the beginning of the month where it only takes begining inventory
Have you considered using a waterfall chart?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
81 | |
76 | |
61 | |
37 | |
33 |
User | Count |
---|---|
99 | |
56 | |
51 | |
42 | |
40 |