Forum Discussion

KarlinOz's avatar
KarlinOz
Advocate III
9 years ago
Solved

timeline slicer missing today when all dates selected

I've just noticed this issue, not sure how long it has been present:

When I select a range (including today), other than the entire range of dates, data for today is included in the output.

 

 

But when the slicer includes the entire range then today's data is excluded:

 

Initially I thought maybe there is too much data for the slicer to deal with (it's only 12k rows) but I removed all rows except the current month (down to 191 rows) but the problem still exists.

 

I don't understand why this is happening but maybe I've configured my project incorrectly. I have a Calendar table and have created a date column in my data table to link my calendar table to.

 

 

   

 

 

 

 

 

 I've put a copy of my sample data here, it'll only be available for 30 days from this post however. Note the names are randomly generated.

 

 

 

Version: 2.49.4831.521 64-bit (August 2017)

Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    KarlinOz

     

    All visual packages are loaded from CDN directly, even if you import package manually.

    It means that your Desktop app uses the latest version of the visual, even if Office Store displays the previous one.

     

    Best Regards,
    Herbert

  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Hi KarlinOz,

     

    As I tried today, it works fine. Could you please check it out?

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    If this issue is fixed, please mark the proper answers as solution.

     

    Best Regards!

    Dale

13 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Click on your timeline slicer visual.  In the menu in the ribbon select the "Format" tab.  Toggle on the 'Edit Interactions'.  What icons do you now see in the other visuals?  If the circle with the line through it is selected, thats the problem.

     

    If thats not the problem, check your arrows in the Table Relationships.  Change them from Single to Both.  You do this by double clicking on the table relationship lines and updating the value in the window that appears.  It should be under 'Cross Filter Direction'

    • KarlinOz's avatar
      KarlinOz
      Advocate III
      9 years ago

      Hi Anonymous,
      Thanks for your suggestions.

      I definitely have the interaction with the slicer turned on:

       

      And switching the cross filter direction to 'both' has no effect.

       

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        9 years ago

        Hi KarlinOz,

         

        As I tested, it did go wrong. I am going to submit an report internally. I will post here if I get any updates.

         

        Best Regards!

        Dale