Handling a Interval Match

Check out this post, and follw their steps.  Your filter will be on the newly created column, just make sure your original Start/End Dates and whatever other data you need are in the graph/chart (Not the newly created dates.)

https://community.powerbi.com/t5/Desktop/Getting-all-dates-between-2-dates/td-p/60577

Hi Senarath

One approach is to do the following,

1. Create a basic Date table using CalendarAuto() but don't relate it to your data table.   In my case I called this table 'Slicer Dates' and I created a slicer over it.

2. Create the following measure which you can use to filter your data

Filter Measure = IF(
			MIN('Table1'[Check in Date])  <= MIN('Slicer Dates'[Date])
		     && MIN('Table1'[Check out Date]) > MIN('Slicer Dates'[Date])		
	         , 1 , 0)

3. Drag the new measure to the Visual Filters of your grid and set it that it has to be 1

There is a PBIX File here

https://1drv.ms/u/s!AtDlC2rep7a-kHAdJz1jWGkPvUTz