Forum Discussion
Solved
Dynamic parameter selection for due days
Hi , I need a parameter on days selection . If i select Closure in the next 10 calendar days . It should show me the category where the closure date is in next 10 calendar days . "X" mentioned belo...
Create a numeric parameter ranging from 1 to the maximum number of days you want to be able to filter for. Then create a measure like
Closure date within X days = VAR ChosenDays = [Num Days Value] VAR RefDate = SELECTEDVALUE ( 'Table'[Closure Date] ) VAR DaysDiff = DATEDIFF ( TODAY (), RefDate, DAY ) VAR Result = IF ( DaysDiff <= ChosenDays, 1 ) RETURN ResultAdd that measure as a filter to your table or matrix visual, set to show only when the value is 1.
Create a numeric parameter ranging from 1 to the maximum number of days you want to be able to filter for. Then create a measure like
Closure date within X days =
VAR ChosenDays = [Num Days Value]
VAR RefDate =
SELECTEDVALUE ( 'Table'[Closure Date] )
VAR DaysDiff =
DATEDIFF ( TODAY (), RefDate, DAY )
VAR Result =
IF ( DaysDiff <= ChosenDays, 1 )
RETURN
Result
Add that measure as a filter to your table or matrix visual, set to show only when the value is 1.
Could you please attach the power bi file for reference
Here you go
Its not working if i select any numbers , its showing same date .