cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
savanah
Frequent Visitor

Using one slicer (Date) with two different tables and two different date columns

Hi All, 

I'm a new in BI and Power BI world..

basically, I have 2 table T1 (ID , ......., Registration date)

T2 (reqest ID , ......., reqest date)
No relationship between them

I want to create one date slicer, that will filter all tables on dashboard..
I try to make table date that contain (ID , Registration date, reqest ID , reqest date) but the filter not work very well..

is there any possible solution
Thank you
 

1 ACCEPTED SOLUTION
alekhved
Resolver I
Resolver I

hi @savanah 

 

Create one date table and join the same date column with the date columns of other two tables. 

 

 

View solution in original post

2 REPLIES 2
alekhved
Resolver I
Resolver I

hi @savanah 

 

Create one date table and join the same date column with the date columns of other two tables. 

 

 

hi @savanah 

 

Please accept it as solution if it works!

 

Thanks,

alekh

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors