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
Anonymous
Not applicable

Date filter active based on another filter

Hello PBI community, 

 

I have the following scenario: I have projects which go through several stages at different dates. I have a page level filter (Filter 1) which filters them based on said stage. I also have a date filter based on the date when these projects were completed (Filter 2). 

The way it is currently configured, when selecting a date range in Filter 2 then Filter 1 "turns" to Completed but the users must remember that if they want to use Filter 1 again they have to reset Filter 2.

Is there a way to make Filter 2 active ONLY when Filter 1 = Completed? 

 

PS: Filter 1 is multi-select so if another value is selected in conjunction with Completed then Filter 2 should not be active

 

Thanks,

 

2 REPLIES 2
Anonymous
Not applicable

@amitchandak it doesn't really solve my problem for a simple fact - in the example, the message card does not entirely cover the matrix table. This works because the matrix data "shrinks" of nothing is selected and "expands" once something is selected. Unfortunately, I can't do the same with a date slicer, I can't overlap only a fraction of the visual, I have to cover more with the message card which leaves no room to click around it. 

Nice idea though 👍

amitchandak
Super User
Super User

@Anonymous , refer if the blog from Matt can help

https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/

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
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 Kudoed Authors