cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ccgbalarin
Regular Visitor

Filter two different databases - Real x Forecast

Hi,

 

I need to create two filters containing "Company" and "Type". The filter needs to reflect on my graph as show below:

ccgbalarin_0-1654115729840.png

When I try to filter by "Type" one of those two values remains the same.

I've tried to create a relation between the two aswell, but no success...

ccgbalarin_1-1654115865109.png

 

All the details are in this PBIX File.

 

Any ideas on how to handle this problem?

Thanks in advance!

1 ACCEPTED SOLUTION
sturlaws
Super User
Super User

Hi,

 

you are trying to filter two different fact tables by using fields within one of them, this is usually not a good idea.

 

Create dimensions/tables for each of the columns the two tables have in common, connect these two new tables to both of the fact tables, and change the slicers to use type and company from these two new tables

pbix

 

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

View solution in original post

1 REPLY 1
sturlaws
Super User
Super User

Hi,

 

you are trying to filter two different fact tables by using fields within one of them, this is usually not a good idea.

 

Create dimensions/tables for each of the columns the two tables have in common, connect these two new tables to both of the fact tables, and change the slicers to use type and company from these two new tables

pbix

 

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

Check it Out!

Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors