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! It's time to submit your entry. Live now!
I have a variable that has single and multiple selections. I want to display a visual that shows the single and multiple selections. For instance, the variable response has the following choices: W, X,Y, Z, WX, XYZ. What is the best way to show WX and XYZ?
Solved! Go to Solution.
Hi @Anonymous ,
Here are the steps you can follow:
1. Create measure.
Measure =
var _count=COUNTX(ALLSELECTED('Table'),'Table'[Test])
return
IF(
_count=1,MAX('Table'[Test]),
CONCATENATEX(
'Table','Table'[Test],""))
2. Result:
Single Choice:
Multiple choice:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @Anonymous ,
Here are the steps you can follow:
1. Create measure.
Measure =
var _count=COUNTX(ALLSELECTED('Table'),'Table'[Test])
return
IF(
_count=1,MAX('Table'[Test]),
CONCATENATEX(
'Table','Table'[Test],""))
2. Result:
Single Choice:
Multiple choice:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
| User | Count |
|---|---|
| 53 | |
| 40 | |
| 35 | |
| 24 | |
| 22 |
| User | Count |
|---|---|
| 134 | |
| 103 | |
| 57 | |
| 43 | |
| 38 |