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.
