Forum Discussion
Use Visual to generate schedule based on currennt inventory level
Hello All,
I'm trying to create a visual in Power BI that will allow user to seleted what processes they wish to run, check those selected processes against current inventory level and return a go or no go statment if that production run is currently possible.
Thanks,
-peter
Hi integrapeter ,
You can absolutely achieve this in Power BI with the right data model and a few DAX measures. The standard setup involves three tables: one for current inventory (including material and stock levels), one for process material requirements, and one for the selectable processes in a slicer. With these relationships in place, DAX can calculate the total material requirements for chosen processes and compare them to available stock, providing a clear “Go” or “No-Go” result.
For visualization, a matrix is typically used to display each material with its required quantity, available stock, and Go/No-Go status. A card visual can summarize overall feasibility, and if you want a schedule-like view, a Gantt chart from AppSource with conditional formatting works well to highlight possible runs.
By selecting processes in the slicer, the model will validate inventory automatically, and the visuals will clearly indicate status.
Thank you,Tejaswi.
4 Replies
Hi integrapeter ,
You can absolutely achieve this in Power BI with the right data model and a few DAX measures. The standard setup involves three tables: one for current inventory (including material and stock levels), one for process material requirements, and one for the selectable processes in a slicer. With these relationships in place, DAX can calculate the total material requirements for chosen processes and compare them to available stock, providing a clear “Go” or “No-Go” result.
For visualization, a matrix is typically used to display each material with its required quantity, available stock, and Go/No-Go status. A card visual can summarize overall feasibility, and if you want a schedule-like view, a Gantt chart from AppSource with conditional formatting works well to highlight possible runs.
By selecting processes in the slicer, the model will validate inventory automatically, and the visuals will clearly indicate status.
Thank you,Tejaswi.
Hi integrapeter ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Regards,
Dinesh
Hi integrapeter ,
I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.
Thank you,
Tejaswi.
