Forum Discussion

adetox's avatar
adetox
Frequent Visitor
1 year ago
Solved

Analyze in excel Date Filter

Hi   I consider myself a pro user of PBI, been using since 8+ years, now I mostly lead a team rather than develop directly. I'm trying to develop a self-serve reporting with XMLA connectors and it...
Need Help
  • adetox's avatar
    adetox
    1 year ago

    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...

Tutu_in_YYC's avatar
Tutu_in_YYC
Super User
1 year ago

I share your frustration.. I ended doing this:
1. 


2. 


Both still dont replace the To From slicer like in power bi...

adetox's avatar
adetox
Frequent Visitor
1 year ago

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

    • adetox's avatar
      adetox
      Frequent Visitor
      1 year ago

      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...

      • v-achippa's avatar
        v-achippa
        Community Support
        1 year ago

        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