cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RicardoHüttl
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

 

RicardoHttl_0-1639089533702.pngRicardoHttl_1-1639089554307.png

 

1 ACCEPTED SOLUTION
ebeery
Super User
Super User

@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_0-1639104498684.png

 

 

ebeery_1-1639104507540.png

ebeery_2-1639104519299.png

 

 

View solution in original post

4 REPLIES 4
ebeery
Super User
Super User

@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_0-1639104498684.png

 

 

ebeery_1-1639104507540.png

ebeery_2-1639104519299.png

 

 

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!

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors
Top Kudoed Authors