sensitivity analysis analysis of 15 categories in same page

[Anonymous]

Hi,

My requirement is as follows:

1)  i want to understand the additional cost impact if a commodity X (say steel) changes by XRs/kg in a quarter for my company. I want this increase/decrease in price to be selected  from a range of values given by me.

2) For one commodity, for 4 quarters, i want to create 4 dropdown lists from which user can select values.

3) But issue is that  they are close to 15 commodities & i want to analyse them all in a same page of dashboard.  So, effectively this is 15*4 ( 60) drop downs & i dont know how to manage all of them in a same page.

Any ideas, how this can be done. 

[Anonymous]

Hi Liu Yang,

Thanks for the reply  & sorry for the delayed response. It solves a part of my requirement.Like, if all the values are already in data table, it will solve the problem. But what if i need to take input from user for every quarter for every commodity, how can i use it. 

[v-yangliu-msft]

Hi  @Anonymous ,

I created some data:

You can try using custom Visual "Smart filter by OKVIz".

Put the column [Group] into it, when you want a category, you can search in the text box.

If you want a category of a quarter, you can also place a slicer with [Date] and [Group] to assist in using.

If you need pbix, please click here.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly