Forum Discussion

scott3387's avatar
scott3387
Frequent Visitor
6 years ago
Solved

Problem with American date format when using selectedvalue in measure only

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

Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    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 )

     

     

2 Replies

  • v-xuding-msft's avatar
    v-xuding-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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.