Filter dates in X axis dynamically in a column chart based on a date slicer selection

Hi Reddy5833 ,

Thanks for reaching out to our community.

After I reviewed your post, I deduce that the crux of the matter is the relationship that exists between the date table and the main table. If you want to keep the relationship, you can modify the measure as follows:

Dynamic Entry Count =
VAR MaxFactDate =
    MAX ( Entries[Entry Date] )
VAR SelectedMinDate =
    MIN ( 'DateTable'[Date] )
VAR SelectedMaxDate =
    MAX ( 'DateTable'[Date] )
VAR DaysRange = [DaysSelected]
RETURN
    SWITCH (
        TRUE (),
        DaysRange <= 4,
            CALCULATE (
                DISTINCTCOUNT ( 'Entries'[Machine ID] ),
                FILTER (
                    ALL ( 'Entries' ),
                    Entries[Entry Date] >= MaxFactDate - 9
                        && Entries[Entry Date] <= MaxFactDate
                )
            ),
        DaysRange > 4
            && DaysRange <= 10,
            CALCULATE (
                DISTINCTCOUNT ( 'Entries'[Machine ID] ),
                FILTER (
                    ALL ( 'Entries' ),
                    Entries[Entry Date] >= MaxFactDate - 14
                        && Entries[Entry Date] <= MaxFactDate
                )
            ),
        DaysRange > 10,
            CALCULATE (
                DISTINCTCOUNT ( 'Entries'[Machine ID] ),
                FILTER (
                    ALL ( 'Entries' ),
                    Entries[Entry Date] >= SelectedMinDate
                        && Entries[Entry Date] <= SelectedMaxDate
                )
            )
    )

I add ALL function to ignore the fitlering of dates. Hope it helps.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.