Forum Discussion

lnoymous's avatar
lnoymous
Regular Visitor
3 years ago
Solved

Unbound Date Picker for use in Table Filter

Hi I am trying to figure out how to use an unbound Date Picker, to use in custom logic in order to create a measure that filters a table.   The problem we are running into is we seem to be unable t...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi lnoymous ,

    Clear. 🙂

    Here MIN() and MAX() return the maximum and minimum values of 'Table' [Date] in the current filtering context, not the values displayed on the slicer. Currently, there is no method to recall the values displayed on the slicer. As you did before, you need to prepare a continuous table of dates for the slicer to ensure that the displayed values are present in the current filtering context.

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

lnoymous's avatar
lnoymous
Regular Visitor
3 years ago

then use the slicer and get the values on the slicer through MIN() and MAX().

Are you referring to gettin gthe underlying data from the datasource attached in the slicer or directly from the slicer yourself?

 

What I am trying to find out is I have a Date Range Slicer as such 

It allows you to pick a custom range that is not necessarily in your data set.

I don't want to do MIN('Table'[Date]) and get back the closest matching date which could be let's say 6/10/2015. I'd want to get the exact values from the Slicer itself (per image above it would bve 6/4/2015).

 

If there is a way to directly get the value from the Slicer as opposed to the underlying source could you share an example of that as I have been unable to find anyway to do that thus far.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi lnoymous ,

Clear. 🙂

Here MIN() and MAX() return the maximum and minimum values of 'Table' [Date] in the current filtering context, not the values displayed on the slicer. Currently, there is no method to recall the values displayed on the slicer. As you did before, you need to prepare a continuous table of dates for the slicer to ensure that the displayed values are present in the current filtering context.

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data