Combining different variables with same values for filtering

[Anonymous]

Hi all, 

I have two charts. In my first chart I have a Car_Color variable that I want to filter on, and it has the values Black and White. In the second chart I have another variable called New_Car_Color and it also has values Black and White.

I want to create a filter to be able to filter both of the charts at the same time. To filter should have the values Black and White, and it should filter both of the charts. How can I achieve this?

My variables are in different tables.

Thanks

[Anonymous]

Hi @Anonymous ,

Can you provide the relationship diagram between the charts?
I create three tables by myself, and I adjusted the relationship as shown below:

However, the creation of a specific relationship needs to be determined by the relationship between your original tables.

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

[CoreyP]

Create a dimension table for your color options, and have a relationship to the car color fields in each table. Use the field from this dim table in your slicer.

[Anonymous]

Actually I tried to create a new table C, with lets say columns Color, Black and White, and Mapped_Color, Black and White. 

I created the relationship between tables A and C, however I could not make active relationship between tables B and C it gave the error of conflicting relationships

[CoreyP]

Make table C in Power Query, not DAX. 

[Anonymous]

Yes I am creating the table C in power query. However tables A and B are connected with a different key that's why it is giving the error