Forum Discussion

richar's avatar
richar
New Member
2 years ago

Relative Date Slicer

I'm working with the Relative Date Slicer in Power BI and I'm interested in capturing the specific selections made by a user. I need to extract the following details from the slicer's settings: Te...
Need Help
Show and Tell
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
2 years ago

richar , I doubt you can programmatically access .

 

But Values(date[Date])  will give you all the dates that selected using slcier. Date[Date] is column use in relative date slicer

 

or

minx(allselected(Date), Date[Date])

 

Maxx(allselected(Date), Date[Date])

 

to get the min and max dates of the slicer

 

sebastiaanw's avatar
sebastiaanw
Regular Visitor
2 years ago

But I think the goal here is to read the user input so that it can be used to compare data against a similar period. So let's say it's the 1st of May, and the user is looking at data from the 1st of April to the 30th of April. We then want to compare this period to a previous period based on the user's selection. However, based on the dates alone, we would not know what to compare it against. Did the user select the last 30 days? Or did they select the last 1 calendar month? Based on the dates, it could be either. So solely based on the dates, we don't know what to compare it against.