2 Different Table having date column - How can i make use in 1 slicer

[Ayappan]

Table 1 has Date column 

Table 2 has Date column 

I am using Data of both Table 1 & 2 in UI .

I want filter the both data using 1 common date slice.

Example :

Red color marked is table 1 

Orange is Table 2 ..How can i use 1 slicer for both..Is it posible 

Thanks

[v-yanjiang-msft]

Hi @Ayappan ,

Has your problem been solved by @amirabedhiafi 's solution? If yes, please consider accept it as the solution to help the other members find it more quickly.

Best Regards,
Community Support Team _ kalyj

[amirabedhiafi]

It is either you : 

- Create a shared/conformed Date dimension table and mark it as Date table as @calerof  mentioned

-You can create a dedicated-seperated date dimensions for each one of the date attributes

if you do wish to link the dimensional attributes to a date dimension, then I find it is better to create separate date dimension tables for each one of your attributes. I will let you discover the inconvenience of this if your data model becomes complex.

You can link all date attributes to the same date dimension table, then you will discover that it will be difficult when applying multiple independent filters.

What if you only want to see products added in X month but you also want to aggregate the sales by the month they were purchased?

Using a single date dimension means that this query is a lot harder than it needs to be. If you have separate date dimensions it is pretty easy to do.

You can read more about role-playing dimensions.

[calerof]

Hi @Ayappan ,

Create a Date dimension table and mark it as Date table in the Data view.

Here is a good explanation from SQLBI how to build one with DAX, eventhough you can do it with Power Query.

https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/ 

Then you create relationships with it.

Hope it helps.

Regards,

Fernando