I am building a “Simulation” model in Power BI. The business is implementing multiple projects over different business functions and locations.
Each of these projects realizes different % improvement in the operations of the business. A project would have:
- a start year
- number of years until it realizes the max % improvement
- and % improvement (Savings) realized
The organization wants to see the effect the changes in these 3 parameters for the different projects would have on the organization as a whole compared to projected outcomes should it implement no projects.
The problem is that we have 3 slicers per project. This makes it 200 + slicers that we “mine” data from which makes us run into serious performance issues. Can anyone suggest the best way to improve performance?
We look at:
- Yearly Energy used during normal operations
- Yearly % savings realized through implementing projects (A variable Calculated using the 3 slicers above )
Is there a way to populate a table from the slicers that can use the selectedvalue from previous/different pages? or use the calculated values from different report pages in a total impact page where put everything together?
Any help or suggestions would be greatly appreciated