Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'd like to create a disconnected slicer that lets choose from date values.
The value given back by the SELECTEDVALUE function always is "#,0.00", and never a date:
With numbers, the slicer works. What am i doing wrong?
Solved! Go to Solution.
The above issue is caused by that you set text type value as default value. Please change your DAX as follows.
selectedValue = SELECTEDVALUE('Dates'[Date3],BLANK())
Regards,
Lydia
The above issue is caused by that you set text type value as default value. Please change your DAX as follows.
selectedValue = SELECTEDVALUE('Dates'[Date3],BLANK())
Regards,
Lydia
Makes sense, now that you mention it. Solved the problem - thanks a lot!