Forum Discussion
DATE filter problem in combined dashboard
Hi BrentDC ,
Do you have any access to the original dataset you're connecting to?
My suspision is that it the Date_Order column actually contains times as well as dates eg 10/08/2021 11:55:31 for example. However in the model is set to format them all just as dates.You can either create a pure date column in your remote dataset or:
If you install Tabular Editor (free version 2 is fine) and connect to your local model try doing:
1) Expand Relationships and click the relationship in question.
2) In the properties pane change the "Join On Date Behaviour" to "DatePartOnly"
Community ChampionPut the date fields from the two ends of the relationship into separate table visuals and have a look at their contents. I'm guessing one end has time parts that don't match.
Hi, still the same problem.
2 tables content without filter 2021
2 separate lists with date (left direct query), right (Dax table).
with filter 2021
With selection only the right table shows the correct data. Left gets empty.
- bcdobbs
Can you create the following measure and drop it into a card visual:
RowTest1 =
CALCULATE (COUNTROWS ( Sales ),
Sales[Date_Order] = DATE (2021, 08, 10)
)
Hi, it gives an empty calculation, really weird...
- bcdobbs
Hi BrentDC ,
Do you have any access to the original dataset you're connecting to?
My suspision is that it the Date_Order column actually contains times as well as dates eg 10/08/2021 11:55:31 for example. However in the model is set to format them all just as dates.You can either create a pure date column in your remote dataset or:
If you install Tabular Editor (free version 2 is fine) and connect to your local model try doing:
1) Expand Relationships and click the relationship in question.
2) In the properties pane change the "Join On Date Behaviour" to "DatePartOnly"