Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@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))
@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))
Hi @amitchandak
Had to slightly tweak the MIN and MAX of date variables. Below is the modified and working measure.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |