Multiply the value of a table column with values selected from two different slicers

[Anonymous]

Hi Team, I have a table x which has different projects and their power generation. 

I then create a simple matrix showing each hour of day against each month and average value of generation something like this:

month/hour	0	1	2	3	4	5
1	124	130	x	x	x	x
2	125	100	x	x	x	x
3	126	1000	x	x	x	x

I have a multi-select drop down box to filter out the projects that i want to see. 

The twist comes here:

I have created two parameters with values from 1-100 and put them into a slicer for selection

I now want to select project 1 and specify a value say 50 selected from parameter1 slicer and select project 2 from the same drop down and select value 60 from the other parameter slicer

What I want now is my matrix to show 50%of generation value for project 1 and 60%generation value for project 2 both in the same matrix chart

[v-yalanwu-msft]

Hi, @Anonymous ;

Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we could close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,

Community Support Team_ Yalan Wu

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

[v-yalanwu-msft]

Hi, @Anonymous ;

I think it can be done . Can you make a simple  example with a screenshot of the scenario to illustrate what you want to output?This will be a little bit clearer.

The most important parts are:
1. Sample data as text or screenshots.
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Looking forword to your reply!

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi team, please see what I wnat to achieve below:

1. I have a drop down box through which i can select multiple values : 2 or more

2. I then need multiple text boxes, 1 each for the project selected in step 1

3. I then need to multiply a column value in my table with the value inserted in the text box in step 2 for that corresponding project selected in step 1 

My concern is: how do i make sure that: 

1. the value inserted in text box 1 corresponds to which project selected from drop down

2. how to muliply a column in my table with the value in the text box, corresponding to the project for which it is entered.

here is an example, i have a drop down from which i selected projects highlighted in yellow, i then inserted values 10 and 20 in two different text boxes, which i have created as a parameter and have values from 1-100, based on the values entered, the value of a particular column within my table gets multiplied by what is entered.

I then need to take the value from the new values (multiplied values) and plot on a matrix graph which i think i will ask once i solve the issue of atleast achieving the multiplied column

thanks friends for helping me!

[Anonymous]

@amitchandak  Yes i also tried creating two separate single select drop down for project_names,

i also created two separate slicer selection for user input of parameter.

I then created two separate measures : measure 1 which will pick the values from drop-down1 and parameter1, multiply the parameter1 value with generation column

similarly, measure 2 will pick data from drop-down2 and parameter2

but the problem arises when i combine these two measures into one, I now want to create a new column with values form these two measures and populate that column onto a matrix visual.

Not sure what am I missing here.Please guide I am in a fix right now.

[amitchandak]

@Anonymous , I doubt you can do that. You need to create a separate slicer for each project value(Numeric) you want to select