Filter Slicer from Measure values

Hi johnt75,

Still no luck!

That's the problem. You need to make sure that when step 1 and step 2 are calculated inside the date visible measure they get the same filters as are being applied in your card visuals.

Hi johnt75,

Thank you for staying with me so far and responding instantly!

Okay. Done!

Solved the Step 1 and Step 2 problem.

Here is the current position:

I used the REMOVEFILTERS()/ALL() function and removed the filters from the Calendar Date column, so that only the last date of sales is considered.

And I used the above mentioned Date Visible measure on the slicer.

A weird thing was happeneing, that when I am using, DATESBETWEEN() function it works, not completely but it works, but when I use the calendar function to get the dates in between the start and end dates, it gives me an error, that the start date cannot be more than the end date.

I wonder if the problems are to do with it being the date table we're trying to filter. Instead of using IN you could try

Date is visible =
IF (
    SELECTEDVALUE ( 'Date'[Date] ) >= [2 Step]
        && SELECTEDVALUE ( 'Date'[Date] ) <= [1 Step],
    1,
    0
)

Hi johnt75,

Tried and still not working.

Sharing a sample file for you to play around it if you will.

I tried this technique as well, but didn't seem to work. Have a look at it.

Create slicer with Custom Time Periods in PowerBI | Time Intelligence | MiTutorials - YouTube

Thank you!

Is Visible = 
VAR CurrentDate = MAX('Calendar'[Date])
VAR Step1 = [1 Step]
VAR Step2 = [2 Step]
RETURN IF( CurrentDate >= Step2 && CurrentDate <= Step1, 1, 0)

gives the correct values in the table, but it doesn't play nicely with the slicer. If I add it as a filter on the slicer then you can't select any dates at all. Not sure what's going on.

Show your data model/post a sample pbix. Most likely the calendar table needs to be disconnected.

Hi lbendlin,

I have shared a sample file in message 13 of the thread. Sharing it again in this post.

If the calendar table is diconnected, then it will not be able to filter out data from the fact tables.

Here is a look at the data model. It is quite basic.

Your measure are a little too complex.  Use these instead:

1 Step = EOMONTH(CALCULATE ( MAX ( 'Sales'[Sale Date] ), ALL () ),-1)

2 Step = EOMONTH([1 Step], - [Parameter Value]  ) + 1

Hi lbendlin,

Changed the measures but still, its not working with filtering the slicer.

Attaching my file again.