how to capture the value entered for relative Date slicer selection

[Anonymous]

Hi,

I have a dateslicer(relative)

 I want to capture the number selected. In this case 19, to do further calculations.

This slicer is applied on Shipping_Date, not on calender date. So MAX(field),MIN(field) are taking the avialable dates from Shipping date instead of the values shown at the bottom of the slicer( 24-3-2019, 11-04-2019)

[v-yuta-msft]

@Anonymous ,

Generally, if you want to refer to selection in slicer, you can use SELECTEDVALUE() function to achieve the value. If this issue still persists, please share some sample data and clarify more details about your requirement.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I have Shipping_Date field with this data( pls note 04-Apr-19 is missing)

01-Apr-19
02-Apr-19
03-Apr-19
05-Apr-19
06-Apr-19
07-Apr-19

08-Apr-19
09-Apr-19
10-Apr-19
11-Apr-19
12-Apr-19

In the relative date slicer shown here, if 9 is selected... I want to capture that number

=> If i use MIN and MAX of shipping_date, it gives 05-04-2019 and 12-04-2019 respectively

So MAX-MIN fails

=> Even if i use SELECTEDVALUE with CONCATENATEX, it misses 04-04-2019

I want to capture value 9, so that i can use it in my calculations

[v-yuta-msft · Accepted solution]

@Anonymous ,

I have made a test on your issue but couldn't reproduce your issue. The missing date shows correctly on my side. Please check if you have installed the lastest version of power bi desktop.

 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SameekshaM]

Hi,

Is There any way i can get the slicer selection from the relative date slicer?

Ex - If the user has selected This Week, This Month or This year. Can i get to know the slicer selection - Week,Month Or Year? 
I tried to use the SELECTEDVALUE() Measure. However, it returns blank.

The var x = MAX(date)-MIN(date) also does not help as it captures MAX & MIN Dates from the available data & does not consider the values shown in slicer selection. Also the value of x is not helpful in calculating values.

I need to know the week/month/day/year selection & the start date for the same to use it in my calculations. Is there anyway i can do it?

[Vickar]

did you find a solution? I'm having similar requirement.

[SameekshaM]

+ @MFelix 
+ @amitchandak 

+ @parry2k 
+ @adams