cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
yuvarajg Regular Visitor
Regular Visitor

Association and required a common filter between two tables

Hi i have 3 table 

 

Table1= Contact_Details[Date]

Table2=Engagement_Details[Date]

Table3=Calender[Date]

Association_date1.pngI have above data model

if i select a blank( Calender[date]), it shows values in a barchart.Association2.png

 

 

 

if i select a particular date(Calender[date]), its not shows any values in a bar chart.

Association3.png

 

Want common date filter and it should associate with all other table.

1 ACCEPTED SOLUTION

Accepted Solutions
yuvarajg Regular Visitor
Regular Visitor

Re: Association and required a common filter between two tables

I found the solution. 

 

In data view all dates are present in date format..

 

but in powerquery all dates are present in datetime format.

after change the date column, datatime format into date format.

 

Association works.

 

 

 

 

5 REPLIES 5
Super User
Super User

Re: Association and required a common filter between two tables

What measure or column aggregation are you using in your chart?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


yuvarajg Regular Visitor
Regular Visitor

Re: Association and required a common filter between two tables

 

Hai,

 

All are columns.

just i loaded the data from source(Table1 & Table2).

In powerbi just  i create calender table(Calender = CALENDAR(DATE(2018,9,1),DATE(2021,12,31))) only.

Community Support Team
Community Support Team

Re: Association and required a common filter between two tables

Hi @yuvarajg,

 

According to your snapshot, it seems like blank item(no matched) can display visual graph. I'd like to suggest you double check your relationships to confirm if they have correct mapping two tables.

 

For example: switch date slicer to between mode with a large date range to apply on visuals.

 

BTW, it will be help if you share some sample data for test.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
yuvarajg Regular Visitor
Regular Visitor

Re: Association and required a common filter between two tables

yuvarajg Regular Visitor
Regular Visitor

Re: Association and required a common filter between two tables

I found the solution. 

 

In data view all dates are present in date format..

 

but in powerquery all dates are present in datetime format.

after change the date column, datatime format into date format.

 

Association works.