cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ausrine Frequent Visitor
Frequent Visitor

Date Format in Card

Hi all, 

I have a dataset with dates in format dd/mm/yyyy. I use measures FIRSTNOTBLANK() and LASTNOTBLANK() to get date boundaries and these are in format dd/mm/yyyy as well. But once I join these dates in a card with measure

= "CALLS BETWEEN " & [FIRST DATE] & "-" & [LAST REFRESH]

I get date format mm/dd/yyyy (see attached).

Any ideas why it changes automatically? Location is set to the UK.

 

Thanks!

Ausrine

 

Untitled.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-yulgu-msft
Microsoft

Re: Date Format in Card

Hi @ausrine,

 

In my test, the date format is "dd/mm/yyyy" in all these three measures, please see below image:

3.PNG

 

Also, I noticed that there is no such a date format "dd/mm/yyyy" option under the format drop down list. We should use Format function to get desired format. [Date] is in default format after loading dataset to Power BI desktop, [Date2] is the returned format.

4.PNG

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Microsoft v-yulgu-msft
Microsoft

Re: Date Format in Card

Hi @ausrine,

 

In my test, the date format is "dd/mm/yyyy" in all these three measures, please see below image:

3.PNG

 

Also, I noticed that there is no such a date format "dd/mm/yyyy" option under the format drop down list. We should use Format function to get desired format. [Date] is in default format after loading dataset to Power BI desktop, [Date2] is the returned format.

4.PNG

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

ausrine Frequent Visitor
Frequent Visitor

Re: Date Format in Card

Thanks @v-yulgu-msft!

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors