Forum Discussion
Scenario Comparison with parameters
RicardoHüttl there are probably lots of ways to do this, but I've attached an example with one possibility. Basically just involves a Material/Cost table, and a single-selection slicer to control which material is selected.
https://drive.google.com/file/d/1kQF5Kf_zDko0N1SuXGB4IvG0LBM_6j5F/view?usp=sharing
@RicardoHüttl it is theoretically possible - you would probably need to duplicate the structure built though (wall 1 material table, wall 2 material table, etc.). At a certain point, I would question whether Power BI is the right tool to be using. In my opinion and experience, doing scenario modeling which requires a lot of flexibility can get pretty cumbersome very quickly in Power BI, and you might be better off just starting with a well-designed Excel model, using Data Validation, lookup tables, etc.
Yeah, makes sense. Thank you again!