Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
Line 1: In a slicer i have "a,b,c,d,e,f,g,h" available.
Line 2: In that slicer i have selected "a,b,c,d,e" from the list in Line 1.
In a card visual, I want to retrun only the first 3 selections from the list in Line 2.
I my case the result will be "a,b,c" .
Please what dax can i use here?
I know this dax will retun all items selected: CONCATENATEX(VALUES('Table[column]),'Table'[column]," , ",'Table'[column],ASC)
But i only want only the first 3 items from this and not all selections.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 9 | |
| 5 | |
| 4 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 13 | |
| 9 | |
| 8 | |
| 8 | |
| 7 |