Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have Relative date slicer and I want to pick exact date range which is selected in drop down.
Is it possible?
Example – Suppose slicer have following value – I want to get exact date range that is 11/18/2021 - 11/24/2021 and store in some variable
Solved! Go to Solution.
@shashankg Yes, as measures:
MinDate = MIN('Table'[Date])
MaxDate = MAX('Table'[Date])
Inside a measure:
VAR __MinDate = MIN('Table'[Date])
VAR __MaxDate = MAX('Table'[Date])
@Greg_Deckler Thanks for your reply,
MIN('Table'[Date]) and MAX('Table'[Date]) gives values from the table. I don't want values from table. for eg, as shown in image,
I want
var 1 = "Last 1 weeks"
var2 = 11/18/2021
var3 = 11/24/2021
These values are coming from relative date slicer.
Hi @shashankg
Unfortunately, Power bi doesn't support this feature currently, you can't get the value which doesn't exist in your table.
The slicer is just another way of filtering, which can only filter based on the values you already have.
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@shashankg Yes, as measures:
MinDate = MIN('Table'[Date])
MaxDate = MAX('Table'[Date])
Inside a measure:
VAR __MinDate = MIN('Table'[Date])
VAR __MaxDate = MAX('Table'[Date])
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |