Obtain aging according to user given date and display it by user given bins

[Anonymous]

I want to create a visual where the user selects a date and we calculate aging of a product based on the difference of days between user given date and effective date. The visual is a bar graph which shows sum of quantities. The bars are categorized based on the bins for ex.(0-3 months,3-6 months,....etc. or 0-30 days,30-60days,......etc.).The bins size is selected by the user. for ex. if user selects 3 weeks, then the intervals become 0-3weeks,3-6weeks, and so on upto 6 bins.

As above,This is what the user will be selecting and the axes(below) will change accordingly.

The final aim is to create 2 such bars for comparison.
I am attaching a sample file below for data in which the Bin table will be available for user to select from and change the X-axis of bins accordingly.
I am stuck on this problem for past 6 days and it would be a great help if you can obtain any lead on this.
If you can even come to a simple static solution without the dynamic abilites it will still be helpful.

[lbendlin]

Buckets cannot be dynamic, they will need to be predefined (but you can pick from that predefined list)

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Anonymous]

I have created the bins according to predefined choices available.

I am attaching a sample file link to onedrive which you can use (Very sorry I was unable to figure out how)
Sample file (1).xlsx
The file also contains all the predefined bins which will be given a choice from.
Let us assume the User selects 3 months for bins 
The user can give 2 dates to comapre the ages based on those dates.
Lets say the dates are (01 may 2021) and (22 February 2021)
Then we need to show the following output

Please let me know if there is something else required.

[lbendlin]

Thank you for the sample data.  Can you please indicate what the rules are for putting products ito buckets? What's the userdate1 and userdate2 about?

[Anonymous]

every product has an effective date connected to it.
We are calculating two different ages based on the userdate1 and userdate2 which are an input from the user end.
The age is calculated by the no. of days between userdate and effective date.
The ruke for putting a product in a bucket is its respective aging days.
For ex. 
userdate1 is (4 feb 2022) and effective date of a product is (2 feb 2022) then the aging days for userdate1 for that product are 2 days. now if the selected bin size is 3 weeks then the buckets will be (0-3 weeks,3-6 weeks, etc.) 3 weeks is 21 days. since 2 days is less than 21 days our product goes in the 0-3 weeks buckets for Userdate1 bar. Similarly we will calculate for userdate2 and show comparison between both the quantities according to the buckets.