Forum Discussion
Date siler issues
Hi Folks, I have one date column in my report as below report date. I need help on below two points.
1. Report Date filter should show only last 3 years data only, here i am using relative date in filter level but it is displaying properly on filters section but in slicer showlevel its not working.
2. Report date i have changed the datatype to dd/mm/yyyy but slicer level it's showing MM/DD/YYYY here i am using same date .
Anonymous
1. You should able to check filter type after expanding.2. Unfortunately, that is the limitation that you cannot change the date format on the date slicer.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
3 Replies
Anonymous , Datatype means data format
Try to change the format here
https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings
Amit, I have tried this option but it's not working for me.
1st point slicer should show only 3years ahead
Anonymous
1. You should able to check filter type after expanding.2. Unfortunately, that is the limitation that you cannot change the date format on the date slicer.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
