I have two different data sets that each have similar information but for different respective "owner groups". I want to add a single slicer on my dashboard that, if for example I select "Dataset 1", it will show information on all my visuals in regards to the owner groups in Dataset 1. Then, if I check "Dataset 2", the visuals will filter and change for the owner groups in Dataset 2. I read on the forums that it is recommended to create a different data set, which I did and it has one column called Owner groups. I then linked the "Ownergroup" column from Dataset 1 -> the new table and "Ownergroup" column from Dataset 2 -> the new table. I added the slicer but nothing happens. Dataset 1 has a column called "Ownergroup" with 5 different groups. Dataset 2 has "Ownergroup" with 6 different groups. I'd appreciate any help! Thank you!
