Forum Discussion
Card date format according to location
Hi all,
I have two card visuals in my report indicating the start date and end date of an event. In these cards I am using two measures - FirstDate() in Start Date and LastDate() in End Date. As shown below
They are working correctly but we have a requirement.
Here the format displayed is dd/mm/yyyy. However the format I want to display should be according to the location of the end user(Using the location set in their browser.). For users in UK this format is correct but for users in US the format should be mm/dd/yyyy in the card. Can anyone tell me if this requirement is possible to implement? If yes then how can we achieve this
Hi Anonymous
Based on my test, if I create a measure like below and use it in a card, it will be in Text format and cannot display in browser's language format. But if I put a Date column into a card visual and select Earliest aggregation type for it, it can display in browser's language format correctly.
Here is my test result in Chrome browser.
You can try using a date column directly and choose the top 5 format options with asterisk(*). This is in Power BI Desktop.
In addition, this thread may be helpful: Help to Change Date Format on Power Bi Service - Microsoft Power BI Community
Other reference: Manage Date Formats in the Power BI Service (mssqltips.com)
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
2 Replies
v-jingzhangCommunity Support
Hi Anonymous
Based on my test, if I create a measure like below and use it in a card, it will be in Text format and cannot display in browser's language format. But if I put a Date column into a card visual and select Earliest aggregation type for it, it can display in browser's language format correctly.
Here is my test result in Chrome browser.
You can try using a date column directly and choose the top 5 format options with asterisk(*). This is in Power BI Desktop.
In addition, this thread may be helpful: Help to Change Date Format on Power Bi Service - Microsoft Power BI Community
Other reference: Manage Date Formats in the Power BI Service (mssqltips.com)
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.Thanks v-jingzhang that worked!