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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
mitchmoore2
Regular Visitor

How do I create a date slicer that filters multiple date columns?

Trying to figure out how I can create a date slicer that can filter accross multiple date columns simeltaniously. I've created a date dimension table, however, I can only create a single active one-to-many realtionship whichs limits me to filtering on only 1 of the 5 date columns at once. I need the visuals to update according to their respective date columns. How can I resolve this? 

1 REPLY 1
TheOckieMofo
Resolver II
Resolver II

You can have multiple relationships between a lookup table (like a date table) and a fact table. However, only 1 can be active at a time. So if you want to leverage an inactive relationship, you would use the function USERELATIONSHIP().

 

The syntax is pretty straightforward. Basically, you would use it as a filter criteria in a CALCULATE function, something like:

 

CALCULATE(SUM([SALES]),USERELATIONSHIP('DATE_TABLE'[DATE],'SALES_TABLE[SECONDARY_DATE])

 

Hope that helps.

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.