Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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]

I have above data model

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

 

 

 

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

 

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

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

       

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Anonymous,

         

        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