Forum Discussion

michael_knight's avatar
michael_knight
Post Prodigy
6 years ago

Merge two slicers

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 

Need Help
Tips and Tricks
Tutorial Requests

6 Replies

  • irobba's avatar
    irobba
    Helper I
    6 years ago

    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?

  • dax's avatar
    dax
    Community Support
    6 years ago

    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.