Date slicer for multiple tables

Question

Hello,&nbsp;I have a table with calendary dates and my slicer is in relation with it. I would like my slicer is an action on&nbsp;both graphs which are built with dates. The first one is a graph based on projects with dates of ask&nbsp;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.&nbsp;Calendar&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Projects&nbsp; &nbsp; Date of Ask&nbsp; &nbsp; &nbsp;Date of Answer01/01/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12/01/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;?02/01/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15/01/2018&nbsp; &nbsp; &nbsp; 18/01/201803/01/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 22/01/2019&nbsp; &nbsp; &nbsp; 1/02/2019

v-jiascu-msft · Answer

Hi&nbsp;Thomasdu43,
&nbsp;
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.
&nbsp;
&nbsp;
Best Regards,

thomasdu43 · Answer

Hi,&nbsp;&nbsp;Thank you for your answer and your help.Please find different files which help you to understand my difficulties.&nbsp;Let me know if you want this example with excel boards and .pbix file.&nbsp;Thank you,Regards.

v-jiascu-msft · Answer

Hi&nbsp;Thomasdu43,
&nbsp;
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.

&nbsp;
Best Regards,

v-jiascu-msft · Answer

Hi&nbsp;Thomasdu43&nbsp;,
&nbsp;
Could you please mark the proper answers as solutions?
&nbsp;
&nbsp;
&nbsp;
Best Regards,

thomasdu43 · Answer

Hi v-jiascu-msft,&nbsp;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.&nbsp;Thank you and regards.

Forum Discussion

Date slicer for multiple tables

5 Replies

Related content

slicer for multiple tables

Common Slicers for Multiple Tables

Disconnected Table-Multiple slicers not syncing

regarding storing multiple tables in lake house

Text slicer: pasting multiple values