Forum Discussion

Chanti's avatar
Chanti
Frequent Visitor
2 years ago

Power Bi Daily Inventory Levels

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 ...
General Comment
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

  • Chanti's avatar
    Chanti
    Frequent Visitor
    2 years ago

    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