Filter Separate Start and End Date Columns with One Filter

[StrangeClimate]

Hello,

I am currently building a power bi dashboard off of my organization's scheduling software to see who is using our services and when over a given time. 

Each line of data represents an event that has a separate start date and an end date column that I have linked to a date table. 

On my dashboard I have created a matrix to display columns for organization, start date, end date, and number of people that is filtered by selecting a date range. 

The problem is if I select 1/1/25 and 1/31/25 the filter will cut out events that have a start date of 12/30/24 and an end date of 01/5/25 or a start date of 1/15/25 and end date of 02/04/2025.

How can I show PowerBi that events that have start or end dates outside of the selected filter but occurr during the selected time range are continuous and should be displayed?

Thanks!

[StrangeClimate]

I was able to use the disconnected table to successfully filter the dates in a table. However the visuals I built off the filtered data do not filter successfully. I have tried to add the same filter parameters without success. Thanks for the continued help.

[Anonymous]

Hi @StrangeClimate ,

As far as I know, this workaround that filtering visual by measure in visual level filter would work only you disconnect or inactive the relationship between the Calendar table and Fact data table.

If the relationship is active, your visual will be filtered by relationship first, it will remove the data out of the slicer range.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[danextian · Accepted solution]

Hi,

You will need to use a disconnected dates table for that  and create a measure that considers what dates are within the ranges. Please see the attached sample pbix.

[Ashish_Mathur]

Hi,

I have solved a similar problem in the attached PBI file.

Hope this helps.