Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello everyone, I would like to create two slicer from to as in my screen below. I currently have a date column that works with the segment slicer between but I need to use it in FROM TO what should I do. do you have a lead. Thanks for your help.
Nico
Solved! Go to Solution.
@NMERCIER , When you use date, You can change slicer to Range slicer and use that as range
you can get two date likes
//only needed if table is not joined, else it will filter range of joined table
measure=
var _max = maxx(allselected(Date), Date[Year])
var _min = minx(allselected(Date), Date[Year])
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))
return
@NMERCIER , When you use date, You can change slicer to Range slicer and use that as range
you can get two date likes
//only needed if table is not joined, else it will filter range of joined table
measure=
var _max = maxx(allselected(Date), Date[Year])
var _min = minx(allselected(Date), Date[Year])
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))
return
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.