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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.