Relationship Issues

[wcloninger]

I have 2 dimension tables. One is the date table, and another is an employees table. I also have 3 fact tables. They all need to have relationships between both date and employees table. The reason is, I want a date slicer and employee slicer for all data on one visual. Is this possible? If so, what are my choices?

[Anonymous]

Hi @wcloninger ,

Yes, it's possible to create a Power BI model where a Date slicer and Employee slicer filter multiple fact tables simultaneously.

Table Name	Relationship	Join Type
Date Table	Fact Table 1	One-to-Many (Date)
Date Table	Fact Table 2	One-to-Many (Date)
Date Table	Fact Table 3	One-to-Many (Date)
Employees Table	Fact Table 1	One-to-Many (Employee ID)
Employees Table	Fact Table 2	One-to-Many (Employee ID)
Employees Table	Fact Table 3	One-to-Many (Employee ID)

Place slicers from the Date and Employees tables on your report. And build visuals using fields from dimensions (Date/Employees) and measures from the fact tables. (example: A table showing Employee Name (from Employees), Total Sales (from FactSales), Total Hours (from FactHours), etc.)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[suparnababu8]

Hello @wcloninger 

Yes, you can. Use Bridge table concept having the values from your employee and date tables. Then connect this bridge table with your dimensions and facts.

Let me know if it works!

Thanks!