Date siler issues

[Anonymous]

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 · Accepted solution]

@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.

[Anonymous]

@Amit, I have tried this option but it's not  working for me.

1st point slicer should show only 3years ahead 

[amitchandak]

@Anonymous , Datatype means data format

Try to change the format here

https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings