Forum Discussion

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 ScheduledStartDate on my dashboard

and the requirement is I have to show line chart of count of ProductionOrderNumbers for each ConfirmedShippingDate.

but the data is not getting filtered according to date filter.

I have tried to merged these two dataentities, but no luck.

Is that possible to filter data from SalesOrderHeader when we have slicer from another data source?

amitchandak
Super User
6 years ago
Aniket_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.
Anonymous
Not applicable
6 years ago
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
- Aniket_PowerBi
  Frequent Visitor
  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.