Filter a table visual using a date slicer

[Anonymous]

Hellp, Power friends,

I have a table (visual) with two date colluns (begin a end date vacation) and a slicer with the vacation date interval. I need to filter the visual to show only the vacations between the slicer date selection. I`ve tried to use measures and a auxiliary table and nothing works. Any ideas?

Thanks

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

I've created a sample for your reference. Please note here we shouldn't create relationship between date table and the fact table.

Measure = 
VAR mind =
    MIN ( 'date'[Date] )
VAR maxd =
    MAX ( 'date'[Date] )
VAR sdate =
    MAX ( 'Table'[S-date] )
VAR edate =
    MAX ( 'Table'[E-date] )
RETURN
    IF ( sdate <= mind && edate >= maxd, "in", BLANK () )

[tarunsingla]

A date filter on your report page will give you the desired results. Please refer the documentation in the link below.

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range