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 ChampionHi 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"
Hi,
Indeed, the original field type of date_order is datetime. I have to change the type in the original database structure. I will try this and let you know if it works.
Hi, It isn't possible to change the orignal fieldtype.
But I've made a new column in the table
A - DATUM = DATEVALUE(Sales[date_order])So I can use this new column to link to the date table and it works.
So problem solved.Many thanks!