Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

  • the two fact tables are communicating with each other via the Opportunity_IDs

    Don't do that.  Use a common dimension table to control both fact tables.