Slicer Showing All dates in calendar Dropdown Rather Than Dates with Data Only

[datacode]

Hi have 2 tables:

1. Calendar: has daily dates for 4 years

2. Fact table: Sales of weekly data

Relationship is on to many.

When I add Date from the calendar table in to a slicer to filter for specific dates, the dropdown shows all dates from the calendar date rathern than only dates where they both have data in common.

Is there any way to get around this other than using the Date column from the Fact table (sales table)?

[Mahesh0016 · Accepted solution]

@datacode Please refer below Snap

SameDate =

IF(

    CALCULATE(

                COUNT('Table'[Invoice Date]),

                TREATAS(

                        VALUES('Table'[Invoice Date]),

                        'Date'[Date]

                       )

            )>0,1,0

)

@datacode THANK YOU!!

[LuizKoller]

IMO, the best solution for this is set the direction filter for both:

There are other solutions, like lateral filters, where "Units" > 0.

[datacode]

Hi @LuizKoller Thank you for your response. I like your suggestion of changing the directional filter, but it does not appear to work on my side. Would there be any other changes I can make?