Forum Discussion

Sokon's avatar
Sokon
Icon for Advocate V rankAdvocate V
9 years ago
Solved

Disconnected Slicer & Date values

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?

  • Anonymous's avatar
    Anonymous
    9 years ago

    Sokon,

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Sokon,

    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

    • Sokon's avatar
      Sokon
      Icon for Advocate V rankAdvocate V

      Makes sense, now that you mention it. Solved the problem - thanks a lot!