Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Multiple Views with different visualizations on same table and aggregation on the derived outputs

Hi All,

 

I have been trying to incorporate Multiple Scenarios within Power BI. I have a set of visualizations that get populated on the basis of certain slicers and inputs of the user in multiple 'What-if Parameters'.

The requirement is to populate the same viz view multiple times with the ability to go back to the previous selection of the slicers and What-If parameters to view a particular scenario (dynamically preferably). The ultimate viz to be populated had to take in all the scenarios put forth and perform aggregation to obtain the 'Overall' tab.

 

The method currently employed is as follows:

  1. Populate Scenario 1 with existing DAX formulations in the back-end and do it on an instance of the Data-X table
  2. Duplicate Tab 1 and make Tab 2. Add a bookmark in Tab 1 to lead to tab 2, while disabling the "Data" and "Display" options within the bookmark - this enables context even though we have 2 instances of the same viz, slicers and what-if parameters on the same table

 

Up until this point, we now have the ability to have multiple scenarios with multiple (unsynced) slicers and what-if parameters.

 

Now, the way I have tried approaching the 'Overall' tab to obtain an aggregation of the multiple scenarios is as follows:

  1. Duplicate Tab 1 to obtain Tab 2. Ensure that the DAX formulations are unrelated (deduped) by making duplicate dimensions and populate the Tab 2 viz with the new visualizations which operate on different instances of the same Data-X table
  2. Copy the (unsynced) slicers and what-if parameters from Tab 1 and Tab 2 to the 'Overall' tab and sync them and make them 'not visible' [via the selection pane] to obtain the final tables from the viz and perform aggregations to obtain required viz o 'Overall' tab

Here, I would like to ask the following of the well-respected Power BI community:

  1. Does Power BI have a more efficient, scalable and dynamic method of incorporating the above-mentioned 'Multiple Scenarios'?
  2. What is a possible method to make this dynamic and scalable to more than 10 scenarios?

Note: The DAX formulations applied to populate the visualizations incorporate complicated mathematical and modelling code, thus making the process of duplication of tabs and de-duping them excruciatingly painful.

 

To the best of my knowledge, I have tried to explain the problem in detail. Please feel free to point out any gaps in my approach and suggest better implementations. Please clarify anything as well, if required.

 

I look forward to your valuable inputs and suggestions.

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    I read this through multiple times and I am still not clear what you are doing exactly. Pictures might help.