Forum Discussion
Date slicer from one data source, not filtering data for another data source
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.
HI Aniket_PowerBi,
Any available relationship between these tables? If not, it obviously not apply filter effect. (power bi use relationship to apply a filter effect to other tables, please check your relationship setting and confirm they are confirmed as 'both' directions)
What is the Direction of Relationship in Power BI?
BTW, did these date values stored with the same data format/type? I don't you can use the date type field to filter on text values. (you can shape and transform your data format in query editor side)
How to Get Your Question Answered Quickly
Regards,
XIaoxin Sheng
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.