Forum Discussion
Analyze in excel Date Filter
Yes Tutu, I realized that I forgot to set my Date Dim as data table. Once done, the timeline works fine. It's good, but still less practical than a from / to filter...
Hi
thanks for the answer. The issue I'm having are that Method 1 only works if you put the date in rows, not in the filter. So if you want all of the data from 2 Aug to 3 sept in a single row, you just cannot.
And method 2...doesn't work. If I click on the Insert Timeline, and I chose the Date dimension...nothing happens
I was able to create one. It may require you to have a dedicated date table.
See if this doc can help with your timeline slicer.
https://support.microsoft.com/en-us/office/create-a-pivottable-timeline-to-filter-dates-d3956083-01be-408c-906d-6fc99d9fadfa
Yes Tutu, I realized that I forgot to set my Date Dim as data table. Once done, the timeline works fine. It's good, but still less practical than a from / to filter...
Hi adetox,
Thank you for reaching out to Microsoft Fabric Community.
Thank you Tutu_in_YYC for addressing the issue.
Thank you for confirming that your issue is resolved. Please consider it accepting as a solution so that other community members can find it more quickly.
Thanks and regards,
Anjan Kumar Chippa
Hi adetox,
As we haven’t heard back from you, we are closing this thread for now. If you have any further issue, please raise a new thread in the community forum, we are ready to assist you on it.
Thank you for being part of Microsoft Fabric Community.
Thanks and regards,
Anjan Kumar Chippa
