Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Need to create a date filter by using slicer which contain start date and end date
when ever report gets loaded its should show default values form
start date should be :01-Feb-2023
end date should be: Today's day ( dynamically)
also when ever user want to change the same start data and end date those option also need to enable in slicer.
Solved! Go to Solution.
Hi @Millar ,
I created some data:
Here are the steps you can follow:
1. Create calculated table.
Table 2 =
DISTINCT('Table'[Date])
2. Create measure.
Flag =
var _mindate=
MINX(ALLSELECTED('Table 2'),'Table 2'[Date])
var _maxdate=
MAXX(ALLSELECTED('Table 2'),'Table 2'[Date])
return
IF(
ISFILTERED('Table 2'[Date])=FALSE()&&MAX('Table'[Date]) >=DATE(2023,2,1)&&MAX('Table'[Date])<=TODAY(),1,
IF(
ISFILTERED('Table 2'[Date])=TRUE()&&MAX('Table'[Date]) >=_mindate&&MAX('Table'[Date])<=_maxdate,1,0))
3. Place [Flag]in Filters, set is=1, apply filter.
4. Result:
Slicer has no selected value
Slicer selected value
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @Millar ,
I created some data:
Here are the steps you can follow:
1. Create calculated table.
Table 2 =
DISTINCT('Table'[Date])
2. Create measure.
Flag =
var _mindate=
MINX(ALLSELECTED('Table 2'),'Table 2'[Date])
var _maxdate=
MAXX(ALLSELECTED('Table 2'),'Table 2'[Date])
return
IF(
ISFILTERED('Table 2'[Date])=FALSE()&&MAX('Table'[Date]) >=DATE(2023,2,1)&&MAX('Table'[Date])<=TODAY(),1,
IF(
ISFILTERED('Table 2'[Date])=TRUE()&&MAX('Table'[Date]) >=_mindate&&MAX('Table'[Date])<=_maxdate,1,0))
3. Place [Flag]in Filters, set is=1, apply filter.
4. Result:
Slicer has no selected value
Slicer selected value
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
New column created under table level
Period = if('DMADP OPEM_ADP_DATE_D'[Date]>EOMONTH(TODAY(),-12)&&'DMADP OPEM_ADP_DATE_D'[Date]<=TODAY(),1,0)
And placed under page filter level set values as 1
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
3 | |
1 | |
1 | |
1 |
User | Count |
---|---|
25 | |
3 | |
2 | |
2 | |
2 |