Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

## Scenario Comparison with parameters

Hey, guys

I'm trying to make a scenario comparison similar to "What if", but using text parameter instead. I have connected a building 3D model to Power BI and need to analyze some situations. For example, if I click a wall that is now made of brick, I have its area and cost (from 3D model), but what if I change its material to drywall or wood frame? What would the cost be? Any ideas on how to do that? I thought using an external database, but can't make the relationship between them. Now the total cost is calculated by "area x unit cost". What I need is to calculate total cost by "area x unit cost for any system".

Thank you

1 ACCEPTED SOLUTION
Solution Sage

@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

4 REPLIES 4
Solution Sage

@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

New Member

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.

Solution Sage

@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.

New Member

Yeah, makes sense. Thank you again!

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Join our Community Sticker Challenge

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors