Forum Discussion
Unbound Date Picker for use in Table Filter
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 TeamIf 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
Hi lnoymous ,
// but I don't necessarily want those filters applied, I want to use those values in my own more complex filters.
If you don't want the slicer to interact with other visuals, you can select the slicer and edit the interaction. This way the slicer becomes a method for getting arguments.
Change how visuals interact in a report
then use the slicer and get the values on the slicer through MIN() and MAX().
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
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.
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 TeamIf 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