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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
kkalyanrr
Helper V
Helper V

Dynamic Date Filter based on a Slicer

Hello,

 

I'm trying to link the date filter with a custom designed slicer, please help me getting desired results..

When we click on the slicer value, the date has to be switched automatically to the year, how can we achieve this?
Please help.
Date FIlter.PNG

3 REPLIES 3
mussaenda
Super User
Super User

Go to Format Tab and Edit the interactions of your slicers

@mussaenda  , here the Year Selection is a local table, we do not have CY 2017,CY2018 in the dataset..

I've used Switch function to display results for the thse years selected.

Yes, still you can edit the interactions. Have you tried?

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.

Top Solution Authors
Top Kudoed Authors