Forum Discussion

12-pune's avatar
12-pune
Frequent Visitor
3 years ago

Common Single Date Slicer

Hi all, Please help with the below scenario: How to make common single date slicer for 3-4 visuals for which data is coming from different datasets.   I have 3 different datasets A,B and C and in...
Need Help
shiva_dongari's avatar
shiva_dongari
Regular Visitor
3 years ago

Hi 12-pune 

 

We can create a common dimension table for dates by using DAX functions like CALENDARAUTO() or CALENDAR(mindate, maxdate)

 

And then create relationships between the calendar table we just created and other tables based on begin_date or end_date as per your requirement. Use calendar table Date column in slicer to make it work.

 

If this doesn't help, please provide sample pbix with dummy data to understand the issue better.

 

If this helps, please accept my response as solution. 👍

12-pune's avatar
12-pune
Frequent Visitor
3 years ago

shiva_dongari Hi Shiva, Thanks for your reply.

I have already created Calendar table but relationship with B and C datasets is not working. (Calendar table with A dataset relationship works) but not with B and C.

It throws an below error:

Kindly help.

  • shiva_dongari's avatar
    shiva_dongari
    Regular Visitor
    3 years ago

    12-pune It seems you already have direct/indirect relationships created between these 2nd and 3rd table. 

     

    To get a better understanding of your model, can you provide sample pbix?

    • 12-pune's avatar
      12-pune
      Frequent Visitor
      3 years ago

      shiva_dongari 

      I have created relationship between calendar table and A dataset, thats why its not allowing me toh create new relationship between calendar table and B,C datasets.

      If that is sorted, common slicer will sort, eventually its not happening.

       

      How can i create sample pbix. its tough one.
      Can we connect on skype ? my id - puneetchoudhary0