Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
michael_knight
Post Prodigy
Post Prodigy

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

Jake.png

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 

6 REPLIES 6
dax
Community Support
Community Support

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
Super User
Super User

Please share the data model and sample data.

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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

Link is not working

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

irobba
Helper I
Helper I

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?

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.