Forum Discussion
Text Listing the Selected Interactions & Filters
I am working on a report that has multiple categorical variables (e.g., age range, sex, race, location) as well as a filter. All of the visuals are interactive, so if the user selects one [or more] groups all of the graphs on the report will be limited to just that combination of groups. For example, a user could select "30-39" on the age range graph and "Male" from the sex graph and all of the graphs would just show 30-39 year old males.
Since there are many variables, and more than one can be selected at a time, I would like to add a card that lists the groups that are currently selected and are currently represented on the graphs. Is it possible to write code for the selected groups?
For example, I would like a card to read "You have selected the following: males, 30-39."
Hi waz02
You can create a Measure and use that in the Card like this:
Measure =
Var _S = selectedvalue(Table[Sex])
Var _A = selectedvalue(Table[age ])
Return
"You have selected the following:" & _S & ", " & _A & "."If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
2 Replies
- VahidDM
Super User
Hi waz02
You can create a Measure and use that in the Card like this:
Measure =
Var _S = selectedvalue(Table[Sex])
Var _A = selectedvalue(Table[age ])
Return
"You have selected the following:" & _S & ", " & _A & "."If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/ - v-henryk-mstf
Community Support