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.
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 |