Earn 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!
User | Count |
---|---|
93 | |
83 | |
77 | |
74 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |