Forum Discussion

Aniket_PowerBi's avatar
Aniket_PowerBi
Frequent Visitor
6 years ago
Solved

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...
  • Aniket_PowerBi's avatar
    Aniket_PowerBi
    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.