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 us...
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 )

     

     

vanessafvg's avatar
vanessafvg
Community 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.