Data slicer between

[Luden76]

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, it gives me the whole date range instead of the filtered date range:

Why?

I only have one table in this report.

[v-xiaotang · Accepted solution]

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.