Intersection Between Slicer Range and Date Range in Table

[sebaskl]

Hello everyone,

I have a dataset with contract data, and each contract has a start date and an end date. Let's call that range Contract Period

I have a main table in my dashboard that has the info about every individual contract, like so:

contract_number	start_contract	end_contract
1	01/01/2020	12/31/2026
2	01/01/2023	12/31/2024
3	01/01/2024	12/31/2024
4	01/01/2024	12/31/2026
5	01/01/2025	12/31/2027
6	01/01/2020	12/31/2021

I want to have a date slicer like this:

I want this slicer to, with the date range chosen, let's call it Slicer Period, only showcase the contracts whose Contract Period intersect in any way with the Slicer Period. With any way, I say every type of interception, like these ones:

I specify this because I only have been able to acheive a slicer that only works for the last type of intersection in the above picture, although I also want the other 3 possibilities included.

To sum up, for the Slicer Range I select with my slicer, I want to see every contract that was active at some point.

I have no idea on how to do this, so if someone could help I would really appreciate it!

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

[sebaskl]

Thank you so much for this... Saved my life ahahaha was going mad because of this problem

[Ashish_Mathur]

You are welcome.

[lbendlin]