Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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 | 
|---|---|
| 8 | |
| 5 | |
| 5 | |
| 4 | |
| 3 | 
| User | Count | 
|---|---|
| 24 | |
| 11 | |
| 10 | |
| 9 | |
| 8 |