Calendar Date Filter

[Anonymous]

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.

[v-xicai · Accepted solution]

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]

Hi @v-xicai ,

Thanks for your reply.

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

Thanks.

[v-xicai]

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.

[Anonymous]

Yes, I tried now its working. Thanks