Forum Discussion
Two slicers (from same column) and one visual show excluded values.
- Anonymous2 years ago
Hi SritejaGolla
Please try this:
Here I create a measure:
MEASURE = VAR _Slicer2 = SELECTEDVALUE ( SeperateTable[Industry] ) VAR _Vtable = SELECTCOLUMNS ( FILTER ( ALL ( 'TestTable' ), 'TestTable'[Industry] = _Slicer2 ), "_Country", [Country] ) RETURN IF ( SELECTEDVALUE ( TestTable[Country] ) IN _Vtable, BLANK (), SELECTEDVALUE ( TestTable[Industry] ) )Then add it to the table visual.
the result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SritejaGolla can you share the file with sample data or some screenshots of what's not quite working? You should be able to make it work with two slicers just as one, but may need to create another disconnected table for this to work and be deliberate which tables you use in each slicer. Then you'll need to modify the DAX a tiny bit to account for your two slicers / tables.
- SritejaGolla2 years ago
Microsoft Employee
AllisonKennedy , the Data looks like
Contry Industry India Oil India Power India Construction US Power US Software UAE Oil UAE Food UAE Electronics
If User selected first slicer "Industry" (which is for selection):
Input ---> Industry : Power [in slicer]
Output --->Country Industry India Power US Power
and User selects 2nd slicer "Oil" (which needs to exclude the country which has Oil)
Input ----> Indutry : Oil [in slicer to exclude]
Output--->Country Industry US Power