Forum Discussion
Aniket_PowerBi
6 years agoFrequent Visitor
Date slicer from one data source, not filtering data for another data source
Hello All, I have two dataentities: 1)ProductionOrderHeaders Fields: ProductionOrderNumber, ScheduledStartDate 2)SalesOrderHeaders Fields: ConfirmedShippingDate I have applied date filter of...
- 6 years ago
Hello Anonymous
So finally I joined both the data entities (ProductionOrderHeaders & SalesOrderHeaders => ProdSOHeader)
Since this date slicer field is from ProductionOrderHeader, I created relation between ProductionOrderHeader and ProdSOHeader(ProductionOrderHeader 1:* ProdSOHeader) which is one to many.
Since I am trying to filter a date field by a date slicer, both the fields are of same type.
amitchandak
Super User
6 years agoAniket_PowerBi , can you share the data model. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.