Forum Discussion
Help with slicer/table visual and contexts
- 1 year ago
Thanks all for the help. I was able to resolve this. I needed create another relationship between Table3 and Table1 (based on the name many-to-many). I was then able to use that relationship, the name of the person from Table3, the name of the company from Table2, ignore all the rest of the filters (ALL(Table1)) and add a set of filters which match the name and the company from above. This resulted in empty data for all names and the correct data for those who matched. I was able to filter the empty's in the visual and that did the trick.
Thanks again for all your help.
+Ram
Thanks all for the help. I was able to resolve this. I needed create another relationship between Table3 and Table1 (based on the name many-to-many). I was then able to use that relationship, the name of the person from Table3, the name of the company from Table2, ignore all the rest of the filters (ALL(Table1)) and add a set of filters which match the name and the company from above. This resulted in empty data for all names and the correct data for those who matched. I was able to filter the empty's in the visual and that did the trick.
Thanks again for all your help.
+Ram