Forum Discussion
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 below would a parameter with dynamic value . Whatever user input there it should show data accordingly .
| Closure in the next X calendar days |
This is my data
| Category | Sub Category | Sales | Quantity Q2 | country | Closure date |
| Furniture | Chairs | 100 | 10 | China | 22/07/2025 |
| Furniture | Tables | 100 | 20 | China | 23/08/2025 |
| Automobile | Cars | 100 | 30 | China | 21/7/2025 |
| Automobile | Bikes | 700 | 40 | China | 21/6/2025 |
| Furniture | Chairs | 100 | 13 | India | 21/8/2025 |
| Furniture | Tables | 500 | 22 | India | 21/9/2025 |
Thanks
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.
9 Replies
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.
Could you please attach the power bi file for reference
Here you go
Sorry i did tried it but its not working . I am getting 1 value even if i select any number on parameter . I need like if i select 20 on parameter . It should show categories having closure date in next 20 days from today .
This calculation worked but i need to change it a bit as it will give past dates than today as well. I included >today in and condition for Var Result.
Hi nish18_1990 ,
Please look into the file attatched below.Hi @nish18_1990 ,
Thanks for the update, please look into the below pbix file.
If this helped, please mark it as the solution so others can benefit too. And if you found it useful, kudos are always appreciated.
Thanks,
Chaithra E.
Hi nish18_1990 ,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Regards,
Chaithra.
