Forum Discussion
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 ...
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.