Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Slider automatic select the latest values

 

Hi everyone 

 

I need help to make my Slider automatic after a week changes. Im not sure this is possible?

I want my slider to select the last 6 weeks including the current week. 

 

Note: I have a filter that filtre WeekOffSetNum less or equal to 0.

 

 

error.png

This is the current code for the column that I use to create this silder

 

WeekOffSet =
IF(
    ISBLANK(
                  WEEKNUM(Dim_Date[Date],2) = WEEKNUM(TODAY(),2) && YEAR(Dim_Date[Date]) = YEAR(TODAY())),
                   "Week " & WEEKNUM(TODAY(),2) - ( WEEKNUM(TODAY(),2) - WEEKNUM(Dim_Date[Date],2)-1 & ""),
           If (WEEKNUM(Dim_Date[Date],2) = WEEKNUM(TODAY(),2) && YEAR(Dim_Date[Date]) = YEAR(TODAY()), "Current Week",
           "Week " & WEEKNUM(TODAY(),2)-( WEEKNUM(TODAY(),2) - WEEKNUM(Dim_Date[Date],2) & ""))
 
Thanks you very much.

 

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , No that is not possible as of now, You have to create a current week like an option for the last 6 weeks. means all 6 week will have same static name

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.