Forum Discussion
Filter multiple date fields with 1 slicer
- Anonymous3 years ago
Hi S_Berg ,
Sorry, as far as I know, it may not be possible to use only one measure to filter 4 Visual different date fields, which will cause conflicts in the conditions, you can create 4 measures and place them in different Visual settings is=1.
Here are the steps you can follow:
1. Create measure.
New Projects = var _mindate=MINX(ALLSELECTED('Date'),'Date'[Date]) var _maxdate=MAXX(ALLSELECTED('Date'),'Date'[Date]) return IF( MAX('Table'[Added])>=_mindate&&MAX('Table'[Added])<=_maxdate,1,0)ACTIVE = var _mindate=MINX(ALLSELECTED('Date'),'Date'[Date]) var _maxdate=MAXX(ALLSELECTED('Date'),'Date'[Date]) return IF( MAX('Table'[Status])>=_mindate&&MAX('Table'[Added])<=_maxdate&&MAX('Table'[Finished])=BLANK(),1,0)Pending Projects = var _mindate=MINX(ALLSELECTED('Date'),'Date'[Date]) var _maxdate=MAXX(ALLSELECTED('Date'),'Date'[Date]) return IF( MAX('Table'[Status])<_mindate|| MAX('Table'[Added])>_maxdate&&MAX('Table'[Finished])=BLANK(),1,0)New Projects = var _mindate=MINX(ALLSELECTED('Date'),'Date'[Date]) var _maxdate=MAXX(ALLSELECTED('Date'),'Date'[Date]) return IF( MAX('Table'[Added])>=_mindate&&MAX('Table'[Added])<=_maxdate,1,0)2. Place the four Measures in different Visual Filters and set is=1.
3. Result:
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 S_Berg ,
Sorry, as far as I know, it may not be possible to use only one measure to filter 4 Visual different date fields, which will cause conflicts in the conditions, you can create 4 measures and place them in different Visual settings is=1.
Here are the steps you can follow:
1. Create measure.
New Projects =
var _mindate=MINX(ALLSELECTED('Date'),'Date'[Date])
var _maxdate=MAXX(ALLSELECTED('Date'),'Date'[Date])
return
IF(
MAX('Table'[Added])>=_mindate&&MAX('Table'[Added])<=_maxdate,1,0)ACTIVE =
var _mindate=MINX(ALLSELECTED('Date'),'Date'[Date])
var _maxdate=MAXX(ALLSELECTED('Date'),'Date'[Date])
return
IF(
MAX('Table'[Status])>=_mindate&&MAX('Table'[Added])<=_maxdate&&MAX('Table'[Finished])=BLANK(),1,0)Pending Projects =
var _mindate=MINX(ALLSELECTED('Date'),'Date'[Date])
var _maxdate=MAXX(ALLSELECTED('Date'),'Date'[Date])
return
IF(
MAX('Table'[Status])<_mindate|| MAX('Table'[Added])>_maxdate&&MAX('Table'[Finished])=BLANK(),1,0)New Projects =
var _mindate=MINX(ALLSELECTED('Date'),'Date'[Date])
var _maxdate=MAXX(ALLSELECTED('Date'),'Date'[Date])
return
IF(
MAX('Table'[Added])>=_mindate&&MAX('Table'[Added])<=_maxdate,1,0)
2. Place the four Measures in different Visual Filters and set is=1.
3. Result:
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