Kevin H on 01 Apr 2017 02:19:51
The improved date slicer is great. However, when using it in Between/Before/After mode, I want the dates to be displayed in the same way as in List/Dropdown mode. (That is, the way I've formatted them in my Power BI data model.)
For example, we format all of our dates like '2017-03-31'. But in Between/Before/After mode, the date slicer always displays dates like '3/31/2017'.
- Comments (2)
RE: Date formatting in date slicer
ISO yyyy-mm-dd date format is a hard requirement in my international organization.
Don't understand why the slicer doesn't just pass through the format of the underlying date field ...
RE: Date formatting in date slicer
Yes! This!
Why are americans still trying to impose the strange dd/mm/YYYY date format when the rest of the world knows better. The ISO 8601 format of YYYY-mm-dd is just as short and has the benefit of being both non-ambiguous and _international standard_!
https://en.wikipedia.org/wiki/ISO_8601