cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MHviid Frequent Visitor
Frequent Visitor

Slicer which filters between two tables with same datatypes

Hi all,

 

So I'm working on a project and is in dire need of help.

 

So I have a project where there exist two different sites, both of these sites gather the same datatypes, but have their own name i.e: Erdin and Oto

 

What I've done so far, is to create an ID for both of these tables(sites) and created a separate with the ID and name of the site to create the relationship.

 

What am I doing wrong? Do I need to create a measure which makes it possible to take values from either site?

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support Team
Community Support Team

Re: Slicer which filters between two tables with same datatypes

Hi @MHviid ,

I'm a little confused about the scenario. Is this slicer not working? Or you can't get the expected result when you filter it?

Can you please share a dummy file or sample data and expected result? Then we can help you as soon as possible.

 

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Best Regards,

Xue

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

MHviid Frequent Visitor
Frequent Visitor

Re: Slicer which filters between two tables with same datatypes

Hi Xue, 

 

I managed to solve the issue myself. I will take the link you attached into account and make a more thorough description next time.

2 REPLIES 2
Community Support Team
Community Support Team

Re: Slicer which filters between two tables with same datatypes

Hi @MHviid ,

I'm a little confused about the scenario. Is this slicer not working? Or you can't get the expected result when you filter it?

Can you please share a dummy file or sample data and expected result? Then we can help you as soon as possible.

 

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Best Regards,

Xue

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

MHviid Frequent Visitor
Frequent Visitor

Re: Slicer which filters between two tables with same datatypes

Hi Xue, 

 

I managed to solve the issue myself. I will take the link you attached into account and make a more thorough description next time.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 430 members 4,338 guests
Please welcome our newest community members: