Forum Discussion

visheshjain's avatar
visheshjain
Impactful Individual
3 years ago

Filter Slicer from Measure values

Hello eveyone, I have 3 tables. Calendar, Sale and Parameter. Parameter has values ranging from 1-24, which are the number on months I want to go back. I am trying to filter a slicer which has ...
Need Help
Show and Tell
Tips and Tricks
visheshjain's avatar
visheshjain
Impactful Individual
3 years ago

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.

 

 

 

johnt75's avatar
johnt75
Super User
3 years ago

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
)