Complex multi layered-parameter scenario modeling analysis

[kxj54590]

Hello Community Users,

I am not sure why my post is not getting answered, i think i posted in the right forum only, if not please correct/guide me.

I have a situation, where i need to create dynamic multiple parameters across 30 - 50 products in a more efficient way to represent in the form of a visual within a report page.

For now, I was able to achieve it by passing one parameter as a slicer and dynamically caluclate the tier level across multiple products. Now, I am thinking to a advance scenario where a user wants to see across each product. 

For instance, below file attached has got input (coming from excel) & rate_dynamic table (what-if-parameter) what if i pass each paramter rate value per product name/product ID. The reason behind thinking this kind of approach is because each product name/product ID has got disparate tier range values. So, if a user wants to punch in each rate, to each product and get dyanamic tier level values. How can that be achieved ? Is there any solution to this kinda situation ?

https://ucmo0-my.sharepoint.com/:u:/g/personal/kxj54590_ucmo_edu/ETtXmnXWmQ5Isn0qZFzAAuMBzrmGe0GCKg1...

@v-yuezhe-msft @parry2k @MFelix @amitchandak @PhilipTreacy 

[MFelix]

Hi @kxj54590 ,

To what I can see from your model , you want the user to change the rate based on a manual input of the user correct. 

Changin or adding values to your data model can only be used by using Power Apps or makning a previous input in a spreadsheet or similar and then updating the model.

Have you checked the PowerApps visualization, so you can have those inputs dinamic?

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/powerapps-custom-visual

[kxj54590]

Hi @MFelix 

I think its a good direction to start for me by leveraging power apps, however, when i was going through the documentation provided, i do see certain limitations to it like need to have latest version, currently I am using Nov 2020 edition which is not a issue, although, the project i am into has certain application usage for development (dont have power apps setup within the project) that entails a road block to solve this complex solution. 

Is there any other work around to it like we can setup a table for multiple products and assign values to each product and then create a parameter?

Thanks

Kxj

[MFelix]

Hi @kxj54590 ,

If I understand you correctly, you can create a table with the following setup:

ProductID	Values
1	10
1	15
1	20
2	10
2	15
2	20
3	10
3	15
3	20

Now you can create a hierarchy slicer for example, or several slicers that are filtered at the product ID and then make you calculation based on the product ID and the values selected.

Another option as refered is to have a file that the users can update and then refresh the Power BI and have the results.