Date slicer for multiple tables

[Thomasdu43]

Hello,

I have a table with calendary dates and my slicer is in relation with it. I would like my slicer is an action on both graphs which are built with dates. The first one is a graph based on projects with dates of ask and the second one presents the same projects with dates of answer. I made a relashionship between the column of my calendar table and the colum of my projects table but it is between calendar column and dates of ask colum. So when i move my slicer, there is just an action on the first graph, not on the second one.

Could you please help me?

Thanks in advance.

Calendar                                Projects    Date of Ask     Date of Answer

01/01/2018                               A           12/01/2018             ?

02/01/2018                               B            15/01/2018      18/01/2018

03/01/2018                               C            22/01/2019      1/02/2019

[v-jiascu-msft]

Hi @Thomasdu43 ,

Could you please mark the proper answers as solutions?

Best Regards,

[v-jiascu-msft]

Hi @Thomasdu43,

Can you share a sample file, please? Please mask the sensitive parts first.

Did you have the relationship between the Calendar table the Answer table? If the relationships are proper and the slicer is from the calendar table, it should work.

Best Regards,

[Thomasdu43]

Hi,  

Thank you for your answer and your help.

Please find different files which help you to understand my difficulties.

Let me know if you want this example with excel boards and .pbix file.

 Thank you,

Regards.

[v-jiascu-msft]

Hi @Thomasdu43,

I created a demo based on your information here. It seems good. Can you share the pbix file or modify my demo which is in the attachment? You can keep only a few records to show the issue and mask the sensitive parts.

Best Regards,

[Thomasdu43]

Hi v-jiascu-msft,

I'm sorry to answer you only now, I had an issue with the Power BI update.

There is a mistake. When I use the slicer between 2018/12/01 and 2019/03/07 I would like no result on the diagram named "Nombre de date de la demande par RTR". Indeed, no answer has been made before 2019/06/01.

Find attached a copy of your demo.

Thank you and regards.