cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

Filter visuals on a page based on two different date slicers

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)Report_Pic.png

 

Thanks

Manoj

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

@manalla , 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))



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

2 REPLIES 2
Highlighted
Super User IV
Super User IV

@manalla , 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))



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Highlighted

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors