Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I've been trying to do this but just can't get it right so I'm here again asking for your help. Thanks in advance.
how do i do this?
none or all selected = all categories are selected
two or more selected = multiple categories
one selected = category name
I can't the "multiple" selection part right. The card always shows "all categories are selected". I wrote something like
measure = if(not(hasonevalue(column_name)),"all",values(column_name))
Proud to be a Super User!
Solved! Go to Solution.
Hi @danextian,
>>I can't the "multiple" selection part right.
Measure not support show multiple values, if your select multiple values, you should merge them to one:
SelectItem = IF(COUNTROWS(ALL(User))=COUNTROWS(ALLSELECTED(User)), "All or None",//check all or none if(HASONEVALUE(User[First Name]), VALUES(User[First Name]),//single CONCATENATEX(VALUES(User[First Name]),[First Name],","))//mutiple )
Regards,
Xiaoxin Sheng
Hi @danextian,
>>I can't the "multiple" selection part right.
Measure not support show multiple values, if your select multiple values, you should merge them to one:
SelectItem = IF(COUNTROWS(ALL(User))=COUNTROWS(ALLSELECTED(User)), "All or None",//check all or none if(HASONEVALUE(User[First Name]), VALUES(User[First Name]),//single CONCATENATEX(VALUES(User[First Name]),[First Name],","))//mutiple )
Regards,
Xiaoxin Sheng
Hi @v-shex-msft
Thanks for your help. I was able to show "multiple". I used countrows(Tabe[User]) since I crossfilter using visuals and not through a User slicer.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |