Forum Discussion

Dwayne_Thomson's avatar
Dwayne_Thomson
Frequent Visitor
8 years ago
Solved

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!

  • Anonymous's avatar
    Anonymous
    8 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

  • Anonymous's avatar
    Anonymous
    Not 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], ",")