Forum Discussion
Solved
Parameter Value selection
Hi , How can i link two parameters together : I created two clustered chart one on the left and one on the right . I created two parameter to show Loss and Sales on the left chart and ...
Hi nish18_1990
Can you please try the below steps to get your results.
1. First Create a table as below.2. Create these four measures.
Total Loss = SUM(Data[Loss])Total Profit = SUM(Data[Profit])Total Quantity = SUM(Data[Quantity Q2])Total Sales = SUM(Data[Sales])3. Now create two measures for the results.For left-----------------Selected Left Metric =SWITCH(SELECTEDVALUE(ForSelection[Column1]),"Sales", [Total Sales],"Loss", [Total Loss],BLANK())For right---------------Selected Right Metric =SWITCH(SELECTEDVALUE(ForSelection[Column1]),"Sales", [Total Quantity],"Loss", [Total Profit],BLANK())Now use it in the chartIf this answers your questions, kindly accept it as a solution and give kudos.
Hi nish18_1990
Can you please try the below steps to get your results.
1. First Create a table as below.
2. Create these four measures.
Total Loss = SUM(Data[Loss])
Total Profit = SUM(Data[Profit])
Total Quantity = SUM(Data[Quantity Q2])
Total Sales = SUM(Data[Sales])
3. Now create two measures for the results.
For left
-----------------
Selected Left Metric =
SWITCH(
SELECTEDVALUE(ForSelection[Column1]),
"Sales", [Total Sales],
"Loss", [Total Loss],
BLANK()
)
For right
---------------
Selected Right Metric =
SWITCH(
SELECTEDVALUE(ForSelection[Column1]),
"Sales", [Total Quantity],
"Loss", [Total Profit],
BLANK()
)
Now use it in the chart
If this answers your questions, kindly accept it as a solution and give kudos.
Thanks !