How to add two filters by creating two relationships between two different tables?

[Anonymous]

Hi everyone,

I have two data tables in Power BI. I have attached samples below.

 

I want to create a dashboard that looks somewhat like this:

I want the visualizations to filter with two different variables, i.e., Date and Equipment. So, the date slicer would filter the visualizations, and when I click on a specific equipment in Visualization A, it would filter the same equipment in Visualization B.

I have managed to do this for date or equipment, one at a time. I know that I cannot have two relationships in Power BI. 

Is there any roundabout to this?

Thanks in advance.

[tamerj1]

Hi @Anonymous 
Here is the sample file amended with correct relationships https://we.tl/t-lykPER8nkC

Also the date table has been modified and the filter table is used in the visual

[Anonymous]

Hi @tamerj1 

Thanks a lot! I think you attached the wrong file with your last message. Can you please send it again?

BR

[tamerj1 · Accepted solution]

@Anonymous 
The link has been updated in the previous reply. Please check and confirm.

[tamerj1]

@Anonymous sorry for that. I'll send to you once I get out of my meeting. 

[tamerj1]

Hi @Anonymous 

create a separate date table that filters both tables and use it in both chats.

Also create filter table that contains all the unique equipments (in your example it will contain only two rows - Euipment 1 & Euipment 2) and use it to filter both tables and in both chats. 

[Anonymous]

Thanks for the reply @tamerj1 .

Do you mean like this?

The date relationship works. But not the equipment relationship.

[tamerj1]

Hi Sameera,

If this is a sample file would you please share it in a download link? thank you

[Anonymous]

https://drive.google.com/file/d/1IwvD1VNBX61BcYofUqsojNYekwacLcZj/view?usp=sharing