Tooltip Filter Context with Slicer on Report Page

Solution File Link: TooltipSlicerExampleReport-Solution.pbix

Thanks for this suggestion. Unfortunately I need the slicer to slice the visual itself. If it is disconnected, this alone won't do that.

Copilot suggested the disconnected slicer table idea as well. 

I was able to cobble together a working model using a disconnected slicer table as one part of the solution, but it doesn't leave a good taste in my mouth. Here's what I did:

1. I created a disconnected date table SlicerDate:

SlicerDate = 
    CALENDAR ( 
        FIRSTDATE('DimDate'[Date]), 
        LASTDATE('DimDate'[Date]) 
    )

2. I created a new measure for my chart visual using TREATAS() to copy the filter from SlicerDate to DimDate,

Number of Days (Slicer Version) = 
    CALCULATE ( 
        [Number of Days],
        TREATAS ( SlicerDate, 'DimDate'[Date] )

3. I then tied my slicer to the disconnected date table 'SlicerDate'.

4. For the cumulative measure, I had to clear the filters on DimDate applied in the original measure with TREATAS(), and then limit them to StartDate and EndDate, like so:

Cumulative Days = 
VAR StartDate = 
    [Slicer Start Date]
VAR EndDate = 
    [Hover Date]
VAR CumulativeDays = 
    CALCULATE (
        [Number of Days],
        FILTER(
            ALL(DimDate),
            'DimDate'[Date] >= StartDate && 
            'DimDate'[Date] <= EndDate
        )
    )
RETURN
    CumulativeDays

Now it behaves as expected:

The only issue that I have is that if I want to add anything else on this page, or sync any slicers on other pages, I have to do this repeatedly for each measure (i.e., create a "slicer version" with TREATAS() ).

PREFERRED SOLUTION: Calculation Groups

1. I could use a calculation group, to eliminate the extra slicer measures. 

Slicer Version = 
    CALCULATE ( 
        SELECTEDMEASURE(),
        TREATAS ( SlicerDate, 'DimDate'[Date] )
    )

2. Reassign the slicer to the disconnected 'SlicerDate' table.

3. Add this calculation group to the legend of the chart visual, and it behaves as expected:

The calculation group is probably the way to go. It's a bit clunky, but it works, and I guess that's the important thing.

I posted a sample PBIX with the original problem and both solutions at the top of the page.

Thanks,

Andy