Forum Discussion

DeepakJha23's avatar
DeepakJha23
Helper I
3 years ago
Solved

Displaying relevant column values based on slicer selection.

Hi Power BI Community,   We are working on a requirement where we want to display the relevant values of column 2 based on the slicer selection made in column 1. Also, the slicer selection is multi...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    Please provide sample data that covers your issue or question completely.

     

    Display = if(isfiltered('Table'[Column 1]),CONCATENATEX(VALUES('Table'[Column 2]),[Column 2],","),"All")
Ahmedx's avatar
Ahmedx
Super User
3 years ago

Is this what you are looking for?

DeepakJha23's avatar
DeepakJha23
Helper I
3 years ago

Ahmedx 

 

Thanks for responding on this query.

 

I tried the DAX you have suggested but due to the 4th line of DAX Table1[column1] = 1, this gave the below error :

 

 

 

The column 1 in my data is text data type.