Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
There is an issue with the date validation in the slicer when using start and end date. The start date will just revert back to what it was if you try to select a date after the end date. What SHOULD happen is if you select a start date after the end date, the end date should be the one to change. This is because the start date is the one being changed it should take preference (this is standard in the computing world). Let me give you an example:
I have a slicer that has all data for 1st Jan 2017 to 31st Dec 2017 selected. We now want to look at the 2018 data, so the logical way to do this will be from left to right (start then end), so we update the start date to 1st Jan 2018. Of course because this is now the day after the end date, it will just revert back to 1st Jan 2017 (which can be easy to miss if you are moving exatly one year forward). Then you put in an end date of 31st Dec 2018.
Now you are expecting all of the 2018 data, but you are actually getting all of the 2017 and 2018 data. This is not logical (both because in English we go left to right and we would normally fill out start then end date) and results in problems all the time.
Please fix this slicer to overwrite the date that you are NOT filling in if required.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.