Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
@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.
@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.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |