Forum Discussion

Luden76's avatar
Luden76
Frequent Visitor
3 years ago
Solved

Data slicer between

Hi guys,   I have a date slicer. When I choose list, the date starts from below, which is correct because I have another filter applied to the report. However, when I choose between option, ...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    3 years ago

    Hi Luden76 

    Thanks for reaching out to us.

    The between type slicer is designed this way.

    As a workaround, you can use measure to interfere with the date range obtained from the slicer. For example,

    when you select date range in between type slicer, use the measure below,

    Measure = 
var _start=MINX(ALLSELECTED('Calendar'),[Date])
var _end=MAXX(ALLSELECTED('Calendar'),[Date])
var _t=FILTER('Table','Table'[date]>=_start && 'Table'[date]<=_end)
return COUNTX(_t,[date])

    Best Regards,

    Community Support Team _Tang

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

v-xiaotang's avatar
v-xiaotang
Community Support
3 years ago

Hi Luden76 

Thanks for reaching out to us.

The between type slicer is designed this way.

As a workaround, you can use measure to interfere with the date range obtained from the slicer. For example,

when you select date range in between type slicer, use the measure below,

Measure = 
var _start=MINX(ALLSELECTED('Calendar'),[Date])
var _end=MAXX(ALLSELECTED('Calendar'),[Date])
var _t=FILTER('Table','Table'[date]>=_start && 'Table'[date]<=_end)
return COUNTX(_t,[date])

Best Regards,

Community Support Team _Tang

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