Forum Discussion
Date dimension integration with inactive relationship
For the context: I have a PBI report which contains two fact tables, the two fact tables are communicating with each other via the Opportunity_IDs and my users requested from me that the date slicers should be aligned (so if the user changes the slicer on the first tab it should be reflected on the second tab as well). On the first tab I have the [Fact_table_1].[Completion_date] and on the second tab I have [Fact_table_2].[Modification_date], when I am trying two channeling the two date fields via the [Date dimension].[Date] the [Fact_Table_2].[Modification_date] is inactive, I know that two-way relationships are not ideal for Power BI, before I re-work the whole data model, is there any way to solve this model conflict?
1 Reply
- lbendlin
Super User
the two fact tables are communicating with each other via the Opportunity_IDsDon't do that. Use a common dimension table to control both fact tables.