date slicer setup

Question

&lt;p&gt; 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 data. Currently its not filtering all datas.&lt;/P&gt;Sl.NoProject NamePlanned StartPlanned Finish1a18/07/202219/08/20222b20/08/202220/09/20223c20/08/202220/09/20224d21/09/202221/10/2022

anonymous · Answer

HI&nbsp;Anonymous&nbsp;
How does your current relationship between table looks like?

anonymous · Answer

I have added a column tag=1 in date table and as well in Project data table. Set relationship as Many - ManyDate(tag)=Projectdata(Tag)

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;
That is a cross join and you will have all rows from second table for each row in the first table and Vice-versa.
The join needs to be on the date column.&nbsp;

anonymous · Answer

I didnt understand the solution . Could you please help to understand more clearly. Thanks

v-easonf-msft · Answer

Hi,&nbsp;Anonymous&nbsp;
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 &gt;= MAX ( 'Table'[Planned Start] )
                &amp;&amp; _selecteddate &lt;= MAX ( 'Table'[Planned Finish] ),
            1,
            0
        ),
        1
    )

&nbsp;
Best Regards,Community Support Team _ Eason

Forum Discussion

date slicer setup

7 Replies

Related content

Between Date Slicer

Date Slicer

Date slider setup for all bookmarks

Date between slicer - Change order

Default Date for date slicer

Sl.No	Project Name	Planned Start	Planned Finish
1	a	18/07/2022	19/08/2022
2	b	20/08/2022	20/09/2022
3	c	20/08/2022	20/09/2022
4	d	21/09/2022	21/10/2022