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