Merge two slicers

[michael_knight]

Hi,

I'm creating a dashboard which shows the progress of employees in the company. We have two teams and the employees move between each company. I can create a report for each company but I want to create a joint report. I'm having some problems creating a slicer which combines in the employee names into one single slicer.

I have two rows with each employee name and I use them in a drop down slicer but I'm wondering if it's possible to combine the two columns and make one single slicer

This is an example of what I'm working with

Company 1 on the left, Company 2 on the right. I want to combine the visuals and silcers together into one single view/slicer. The visual are fairly straight forward, it's just the silcers I'm having problems with

Any help would be welcomes

Thanks in advance,

Mike 

[dax]

Hi michaelknight94, 

According to your description, it seems that you want to use one slicer to control different visula from different table, right? If so, you could create slicer table like below

Table 2 = DISTINCT(UNION(DISTINCT(T3[name]), DISTINCT(T4[name id])))

Then  create relationship between this table and other tables, then use this field in slicer to see whether it work or not.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Please share the data model and sample data.

[michael_knight]

Hi @amitchandak 

Here's the link:

https://www.dropbox.com/s/ojxkg7fj5rjdf1i/Acquisitions%20-%20Community.pbix?dl=0

Used to wrong terminology. I didn't mean merge two tables, I meant two columns within the same table. Apologies

Thanks,

Mike

[amitchandak]

Link is not working

[michael_knight]

My bad. This link should work now

https://www.dropbox.com/s/orkigqemlm2slnh/Acquisitions%20-%20Community.pbix?dl=0

[irobba]

Hi Michael,

Not sure what your data looks like but the simplest option to me seems to be combining the 2 tables in to one then basing your slicer on that. Would that be an option for you?