Forum Discussion
Outputting values from column as a list
Hello PBI Community,
I have a interesting request from one of my clients: they would like to be able to see a summary of all filters that are applied to a given report. I used the ISFILTERED() function to create a card visual that lists the dimensions that are filtered, but they would like to be able to see which values are being shown. This works just fine when they have sliced or filtered for just one value, but how can I show when more than one is selected? My DAX is below.
Applied Filters =
var myvalues = VALUES(mytable [ dimension_column ))
return
IF(ISFILTERED( mytable [ dimension_column ) = FALSE(), "Not filtered", "Column Name:" & UNICHAR(10) & mylist)
when only one value is selected in the slicer, the output is
"Column Name:
Selected Value"
Obviously, when more than one value is seleced in the slicer, variable "mylist" will have more than one value and the function fails. my question is, how can I convert the column myvalue to a list in DAX, so I can output each and every value?
what I want to get is
"Column Name:
Selected Value1, Selected Value2, etc."
Am very interested in this solution!
Thank you!
- Anonymous8 years ago
Dwayne_Thomson from what understand you have a list of filters which are being filtered in a column. Now you want to provide all the values in the column seperated by a , or something.
I would use a CONCATENATEX(TableName, TableName[Col Name], ",")
2 Replies
- AnonymousNot applicable
Dwayne_Thomson from what understand you have a list of filters which are being filtered in a column. Now you want to provide all the values in the column seperated by a , or something.
I would use a CONCATENATEX(TableName, TableName[Col Name], ",")
- dlt1697New Member
This works, and thanks!