Filter visuals on a page based on two different date slicers

[Anonymous]

Hi, I have requirement as explained below, and please refer to attached picture.

There are two date slicers. User can select only one date in each slicer, like Start Date and End Date respectively. I am not using Range as user want specifically two boxes to select.

Now coming to the need, i want the table and bar graph to show only the two dates that user selected from both slicers. Right now on the picture/report they show all the dates.

Basic need is, based on the selected two dates by user, i need to show only those Month end day records in all the visuals on the page. Also we need to calculate Sales difference between those two days (I have already acheived this over measure)

Thanks

Manoj

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

measure =
var _min = maxx(allselected(slicer_start),slicer_start[date])
var _min = maxx(allselected(slicer_end),slicer_end[date])
return
calculate([measure4], filter(Table(2),Table(2)[Date] = eomonth(Table(2)[Date],0) && Table(2)[Date] >= _min && Table(2)[Date] <=_max))

[Anonymous]

Hi @amitchandak 

Had to slightly tweak the MIN and MAX of date variables. Below is the modified and working measure.

measure =

var mind=CALCULATE(MIN('Table (2)'[Date]), FILTER(ALL('Table (2)'),'Table (2)'[Date] in VALUES(slicer_Start[Date])))

var maxd=CALCULATE(MAX('Table (2)'[Date]), FILTER(ALL('Table (2)'),'Table (2)'[Date] in VALUES(Slicer_End[Date])))

return

calculate(sum('Table (2)'[sale]), filter('Table (2)','Table (2)'[Date] = eomonth('Table (2)'[Date],0) && 'Table (2)'[Date] >= mind && 'Table (2)'[Date] <=maxd))

Thanks

Manoj