Disconnected Date Slicer

Hi seryan ,

Please have a try.

One possible solution is to use a measure that calculates the active services for each date, and then use that measure as a filter for your visuals. For example, you can create a measure like this:

Active Services =
VAR SelectedDate =
    SELECTEDVALUE ( D_TIME[Date] )
RETURN
    CALCULATE (
        DISTINCTCOUNT ( F_SERVICE[SERVICE_KEY] ),
        FILTER (
            F_SERVICE,
            F_SERVICE[EFFECTIVE_FROM_DATE] <= SelectedDate
                && (
                    F_SERVICE[CANCELLATION_DATE] >= SelectedDate
                        || ISBLANK ( F_SERVICE[CANCELLATION_DATE] )
                )
        )
    )

 This measure will return the number of distinct service keys that are active on the selected date, based on the effective from date and cancellation date in the fact table. You can then use this measure as a filter for your visuals, and set the filter condition to be greater than zero. This way, you can ensure that only the active services are shown in your visuals, regardless of the non-fact information.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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