Dynamic parameter selection for due days

[nish18_1990]

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

[v-echaithra]

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.

[v-echaithra]

Hi @nish18_1990 ,

Please look into the file attatched below.

[v-echaithra]

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.

[johnt75 · Accepted solution]

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.

[nish18_1990]

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.

[nish18_1990]

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 . 

[nish18_1990]

Could you please attach the power bi file for reference

[johnt75]

Here you go

[nish18_1990]

Its not working if i select any numbers , its showing same date .