Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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."
Solved! Go to Solution.
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/
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/
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 38 | |
| 37 | |
| 28 | |
| 28 |
| User | Count |
|---|---|
| 124 | |
| 89 | |
| 73 | |
| 66 | |
| 65 |