Forum Discussion

Afkkek's avatar
Afkkek
Frequent Visitor
6 years ago

Earliest Date on a slicer does not work

Hello,   I'm attempting a report with multiple years of history for a group of investments, but with one tab specific to year-to-date data.  A calendar fact table is set up in conjunction with the ...
Need Help
Tips and Tricks
Afkkek's avatar
Afkkek
Frequent Visitor
6 years ago

Thanks for your response!  Perhaps I should have included screenshots and/or been more clear.

 

Note in the two screenshots below, a slicer is used to restrict the available dates available to the user.  In the first screenshot for example, it is set at Jan 14, 2019 to Dec 31, 2019 and the results are as expected.  However, in the second screenshot, if the beginning date gets set at the earliest possible value in the slicer, which is Jan 1, 2019, then for some reason it returns ALL the available dates on the fact table, effectively ignoring the slicer.  Building the slicer on both the calendar table or the fact table date column has the same effect.

 

Starting