Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I have these Wave values as my Slicer:
My goal is if I choose Wave 68, it should filter my Values table with all records based on the selected Wave (68) and the 3 previous Wave (65-67):
More example:
Thanks in advance!
Hi @jsevillaiv x
1. Create a new table to use it as a slicer
SlicerTable = DISTINCT('OriginalTable'[Wave])
2. In your original Table create a new measure
RightValues=
VAR SelectedWave = SELECTEDVALUE('SlicerTable'[Wave])
VAR FilteredTable =
FILTER(
'OriginalTable',
'OriginalTable'[Wave] >= SelectedWave - 3 &&
'OriginalTable'[Wave] <= SelectedWave
)
RETURN
MAXX(FilteredTable, 'OriginalTable'[Values])
3. Add a new slicer with the Wave column from the SlicerTable
4. Add Wave and RightValues into a a visual Table
Apply it and let me know 👍
Did it work ? Mark it as a solution to help spreading knowledge
Was this exchange helping? A kudos 👍 would be appreciated
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.