Forum Discussion
Helper IINeed Slicer date format in ISO Date format i.e YYYY-MM-DD
Hi Team,
Right now my Slicer date format is either in DD-MM-YYYY (i.e English UK) or MM-DD-YYYY(English US) which inturn depends on Browser Language-Date setting.
Is there any way to have the slicer Date format change to ISO standard i.e YYYY-MM-DD?
Below is the screenshot of current slicer.I have changed the date format to YYYY-MM-DD,but Slicer date format is not changing.
Can Someone please look into this and suggest a feasible solution.
5 Replies
- Greg_Deckler
Community Champion
adityakumar619 Perhaps try a custom format string for your Date column of "YYYY-MM-dd" although I think there is a standard date format for that as well.
adityakumar619Greg_Deckler Thanks for the suggestion,I tried this option before aswell,this applies for Data column in the table,but not to the slicers.
i Got that Slicers date format is avaible in major forms based on browser settings i.e English UK -DD-MM-YYYY.And Engish US MM-DD-YYYY.But somehow i need in ISO format
Hi there, Ever got an answer?
Even with the new visual "Data Format" forcing YYYY-MM-DD, the "between" slicer is showing dates in M-D-YYYY. I do not like M-D-YYYY
Hi adityakumar619 ,
Please check if this topic could help:
https://community.powerbi.com/t5/Desktop/date-format-in-slicer/m-p/215627
Best Regards,
Jay
- adityakumar619
Anonymous I have gone through that topic earlier,that topic is conversion of MM/DD/YYYY to DD/MM/YYYY.And this can be possible.
My query is conversion to ISO date format i.e YYYY/MM/DD,which is not covered and i have raised a development request to Microsoft Powerbi Dev team.Below is the link.
