Forum Discussion
Return date from slicer
I have a potentially simple problem, but even chat gpt cannot solve it.
Table DATE_DIM, field: [Week Start Date].
This field goes into a slicer.
I want to create a measure which will return exactly that date. And I am getting blanks. Why?
Formula (using several ones, all give me blanks):
Selected Week Start Date =
SELECTEDVALUE(Date_DIM[Week Start Date])
Hi some_analyst
Did you use the same column in your slicer as in your measure? And is visual interaction enabled between the slicer and the card?
4 Replies
hello some_analyst
i am not sure, but your DAX should be good.
unless if you did not select any date in slicer, then it would be return as blank.
Hope this will help.
Thank you.
Thanks Irwan , I am really confused because I have the selected date
and the formula is this:
Slicer Select Week Start Date = SELECTEDVALUE(Date_DIM[Week Start Date])This date slicer filters the rest of the dashboard, just not this measure, there is definitely data there. I have no clue
Hi some_analyst
Did you use the same column in your slicer as in your measure? And is visual interaction enabled between the slicer and the card?
