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

Why?

I only have one table in this report.

 

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.

1 Reply

  • 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.