Need Slicer date format in ISO Date format i.e YYYY-MM-DD

[adityakumar619]

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.

[v-jayw-msft]

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]

@v-jayw-msft 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.

https://community.powerbi.com/t5/Issues/Slicer-Date-format-needs-to-be-in-ISO-Date-i-e-YYYY-MM-DD/id...

[Greg_Deckler]

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

[adityakumar619]

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