Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calendar Date Filter

Hi All,

 

I have for dates in File Date column.

I created a calendar table with the help of CalendarAuto() and now i have dates from 1/1/2019 to 12/31/2019.

I need to place the Date field(calendar Table) in slicer and i dont want my File Date in slicer because of some other requirements. But i would like to see only those 4 dates should be present in dropdown when i keep that in slicer which is present in file date.

Is that Possible?

 

Thanks in Advance.

Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Anonymous ,

     

    Based on having created relationship between the Calendar table and the file fact table, you can apply Visual level filter for the Date slicer visual following steps below.

     

    1. Create a bar chart visual, put the calendar[Date] into this visual.
    2. Drag 'file fact table'[File date] into Visual level filter of the chart visual and make some selections as your need.
    3. Turn the chart visual back into a slicer.

     

    Best Regards,

    Amy

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • v-xicai's avatar
    v-xicai
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Based on having created relationship between the Calendar table and the file fact table, you can apply Visual level filter for the Date slicer visual following steps below.

     

    1. Create a bar chart visual, put the calendar[Date] into this visual.
    2. Drag 'file fact table'[File date] into Visual level filter of the chart visual and make some selections as your need.
    3. Turn the chart visual back into a slicer.

     

    Best Regards,

    Amy

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi v-xicai ,

       

      Thanks for your reply.

       

      I tried as per your suggesstion but unfortunately it is not working.

       

      Thanks.

      • v-xicai's avatar
        v-xicai
        Community Support
        6 years ago

        Hi Anonymous , 

         

        You may need to create relationship between the two tables, and pay attention to the steps above. For the step1, you may create a bar chart visual or other visuals instead of Slicer visual first of all, then put the calendar[Date] into this visual. It works in my test.

         

        Best Regards,

        Amy

         

        Community Support Team _ Amy

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.