Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

Date formatting in date slicer

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'.
Status: Needs Votes
Comments
arvid_baarnhiel
New Member
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
fbcideas_migusr
New Member
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 ...
craig_sarvis
New Member
Can't believe this doesn't have more votes. I work in an international company and long ago we standardized across the business on ISO date format (YYYY-MM-DD) to resolve misinterpretations. My users are bugging me all the bloody time about this silliness. The appearance of dates in this slicer must match the format of the source data. End of story. Note that solution suggested in the community forums for users to change the regional setting of their operating system does NOT work, as that is not respected by Chrome or Edge.
Wojciech_Grusz1
New Member
This is ridiculous that between slicer ignores ALL REGIONAL SETINGS! Ignores browser model setting, ignores browser settings, ignores system regional settings and uses literally the WORSE possible format mm/dd/yyyy Microsoft this is not an idea. This is clearly a bug.
Thomas_Jude
New Member
It would be great if an option to select "ISO Week" is also available for the "Relative date"
 
silvija_kantusc
New Member

One more vote for this very usefull and necessary feature!!!

philliphemstock
New Member

This is still a sorely needed feature! Can't believe it's been on here since 2017!


Please get this sorted Microsoft

DEEPANSHU_BISWA
New Member

Slicer in the new update is not as friendly as it was. The slicer can't give " from "to dates.


The conditional formatting is missing in the field Even the count and auto establish of column and parameters is missing.

jack_bryde
New Member

Can't believe this isn't standard

EGKFC12770
New Member

We need the choice of date to be open, such that you choose the date according to what you need from one period to another