Forum Discussion
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 select so it should show ALL in the card box when no selection is made.
See the image below for more details :
In the above slicer, ALL is selected but the display card shows the default first value(A) instead it should show ALL.
If the slicer is changed to 1, the display card should show A,B.
If the slicer is multi selected to 1,2 display card should change to A,B,C,D.
I would appreciate any help on this.
Thanks,
Deepak
amitchandak Sahir_Maharaj lbendlin
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")
8 Replies
Is this what you are looking for?
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.
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")
