When using a date slicer it would be great if it existed an option "earliest date" (or latest). The issue is that when you have a table that is constantly adding new records, with a date column, ...
Hello, I need your help in creating a default slicer Option:
Scenario: I want to create a slicer which always selected latest yearmonth as Default selection (for example when user open report on September2019 he has to see 2019-sep as selected) and he also able to select previous yearmonth data.
Query Mode: IMPORT
Data I have is for 2017,2018, 2019 and I also have date column and yearmonth column(yyyy-mmm). So, I want to create a slicer with default latest yearmonth as selected and also users can select other years data if they want to.
I also don't want my users to see selection like Text 'latestyearmonth' they just have to see 2019-sep, 2019-Aug so on....
Help me resolve this..!!!