Get selected dates from a relative date slicer

[Anonymous]

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!

[Anonymous]

Hi @v-rongtiep-msft is there a way you can select the items on the left side selection box with Last, Next and This? I would like to have my users only view the "This" category and the others to not be seen when you selct that box.

Best,

Marlon 

[v-rongtiep-msft · Accepted solution]

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