Problem with American date format when using selectedvalue in measure only

[scott3387]

Hello,

I have a table generated with the below just for slicers/filters. The table is set to dd/mm/yyyy format

Dates = CALENDAR(TODAY()+1, TODAY()+28)

I also have a measure that I want to use for a dynamic title 

Title Date = var selecteddate = SELECTEDVALUE(Dates[Date]) return "Date: "& if(isblank(selecteddate), "All Dates", selecteddate)

Literally everywhere else in my report, dates are european style dd/mm/yyyy values but this one returns american mm/dd/yyyy.

Any ideas why and how to fix?

Thanks

[v-xuding-msft · Accepted solution]

Hi @scott3387 ,

Based on your formulas, I think you just want to show the selected date in a Card visual. If so, you could add a FORMAT function like below to show normally.

Note: The function of Format can convert values to text.  So I change the condition of isblank(selecteddate) to selecteddate = "".

Title Date = 
VAR selecteddate =
    FORMAT(SELECTEDVALUE ( Dates[Date] ),"dd/mm/yyyy")
RETURN
    "Date: " & IF ( selecteddate = "", "All Dates", selecteddate )

 

[vanessafvg]

i would just probably swap them around in power query are you importing the data in?  so take that column and swap the month and days around in power query.