Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 .
Solved! Go to 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
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.
@Amit, I have tried this option but it's not working for me.
1st point slicer should show only 3years ahead
@Anonymous , Datatype means data format
Try to change the format here
https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |