topic Get selected dates from a relative date slicer in DAX Commands and Tips

Get selected dates from a relative date slicer

Anonymous — Wed, 08 Jun 2022 05:34:55 GMT

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!

Re: Get selected dates from a relative date slicer

Anonymous — Mon, 13 Jun 2022 01:41:45 GMT

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

Re: Get selected dates from a relative date slicer

Anonymous — Tue, 21 Jun 2022 03:19:39 GMT

Hi Anonymous 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