Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

date slicer setup

<p> I have a date table and another Project data table with Planned start and Planned Finish. How to connect these two tables..so that if i put a slicer for date table, it picks and filters correct d...
Need Help
v-easonf-msft's avatar
v-easonf-msft
Community Support
4 years ago

Hi, Anonymous 

If you have a seperate calendar table ,you can create a measure and apply it to table filter pane to filter data.

visual filter = 
VAR _selecteddate =
    MAX ( 'Calendar'[Date] )
RETURN
    IF (
        ISFILTERED ( 'Calendar'[Date] ),
        IF (
            _selecteddate >= MAX ( 'Table'[Planned Start] )
                && _selecteddate <= MAX ( 'Table'[Planned Finish] ),
            1,
            0
        ),
        1
    )

 

Best Regards,
Community Support Team _ Eason

Anonymous's avatar
Anonymous
Not applicable
4 years ago

and also its not working on Cards visual