Hi, This is still unresolved. I tried it multiple times, but couldnt figure out.
In general, according to my query, I want to plot a line graph where I can select from two parameters created by me.
for example: First parameter name is Location with values Loc1, Loc2, Loc3 and Loc4.
Second parameter is Values with Val1, Val2, Val3 and Val4.
Now, If i select Val1 from Values and Loc1, Loc2 from Location, the line graph should have 2 line graphs.
I tried calculation fields too by ifelse(location=loc1 and values=val1 then loc1val1, and so on, null).
To my understanding, I don’t believe multi-value parameters allow this type of integration. When building the ifelse statement, you have to setup it to equal, greater or lesser, if two or more selections get made (from the multi-value parameter) the logic no longer matches as it’s not only equaling one value but trying to equal 2 or more.
What if you tried utilizing 3 controls, one for the weather and two for each location that you’d like to compare since you mentioned that you were able to get this to work with a single-select parameter.
Let me know if this could solve as a work around for this scenario.
Thanks @Brett for your comment.
I would like to mention that there are 8 weather variables and 6 locations.
I planned to have 2 parameters, one for weather and one for locations, a multi-select parameter. Based on which, If i choose ex. Temperature from weather and Loc1 and Loc2 from Locations, i get the desired line graphs in single chart. Unselect these and selecting any other variable and location for further analysis.
Yes, I understand that you’re trying to use a multi-value parameter but as I mentioned, this is a current limitation within Quick Sight; which is why I suggested utilizing an additional location parameter so that you can select one location in each. With this, you can create separate calculated fields for each location parameter and this will provide you with the 2 lines that you’re looking to achieve.