Forum Discussion
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...
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")
lbendlin Thanks for responding.
Unfortunately, it worked on the sample data how you have posted above but when I tried this on the actual data the display card is showing repeated values.
Like if I select 1 in the column1 slicer , display card is showing A,A,A,A,A...... instead it should only show A.
We have long string values in column 2.
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")lbendlin Thanks. Using the VALUES solved the issue. Really appreciate your help.