Forum Discussion
Get selected dates from a relative date slicer
Hi Everyone,
I'm trying to get the values of a date slicer using SELECTEDVALUE. Does anyone know how I can go about this especially for relative dates selection (see below).
Essentially i would like to control the selection so for example when a user switches the Year drop down to Day/Week/Month I should get different results.
Is this possible using dax?
Appreciate your Help!
Hi Anonymous ,
I have created a simple sample, please refer to it to see if it helps you.
Create a measure first.
Measure = SELECTEDVALUE('Table'[date])Measure cannot be displayed separately in the visuals. So we can create a column.
Column = [Measure]If I have misunderstood your meaning, please provide your desired output with more details and you sample pbix file without privacy information.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
2 Replies
Hi Anonymous ,
I have created a simple sample, please refer to it to see if it helps you.
Create a measure first.
Measure = SELECTEDVALUE('Table'[date])Measure cannot be displayed separately in the visuals. So we can create a column.
Column = [Measure]If I have misunderstood your meaning, please provide your desired output with more details and you sample pbix file without privacy information.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly