Forum Discussion

Thomasdu43's avatar
Thomasdu43
New Member
7 years ago

Date slicer for multiple tables

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 p...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

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's avatar
Thomasdu43
New Member
7 years ago

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's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    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.

    Date-slicer-for-multiple-tables

     

    Best Regards,

    • Thomasdu43's avatar
      Thomasdu43
      New Member
      7 years ago

       

      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.