Forum Discussion
RamEHG
1 year agoFrequent Visitor
Help with slicer/table visual and contexts
Hi Folks, Still a newbie to PowerBi so looking for some help here. To set the context, I have 3 tables. Table 1: UniqueID | Name | Company | Topic Dis1 | Ram | Comp1 | Powerbi Dis2 | Ram |...
- 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
Ashish_Mathur
Super User
1 year agoHi,
I have solved a similar question in the attached file.
Hope this helps.