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 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
ebeery, that's exactly what I need, thank you very much!
let me ask you another question, please. what if I want to use multiple materials? Something like wall 1 - wood, wall 2 - drywall ,and the others walls brick, using the same table. In this case, I want to analyze the impact on global cost if I change just one or two walls, not all of them.
@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!