Forum Discussion
Issue in displaying date format
Hi, I have a date format in a slicer like 202106 and 202405. I want to show these dates in an alphabetical way like "June 2021 to May 2024". I have data from the backend that starts from 1990 ...
As shown in the screenshot
If I try to choose "To Date" which is 202405, currently we are in May 2024 which is the latest. It should display May 2024 instead of January 2040. Even if I choose any future dates from now, automatically it should replicate the selection which I made but, by default, it is choosing the max date which we have given at the backend level.
Likewise, the same with the "From Date". It defaults to 1990.
Also, I have made a custom date format which displays only the Year and month in the slicer.