Forum Discussion
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...
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 )
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 )