Data Range in Power BI

Hi Guys!!

I landed into very weird kind of requirement, the same has been detailed below.

Source Data : 

Filters :

1. Channel 

2. Type

3. Year

So far, I have created my Power BI report with above mentioned filters (Channel,Type and Year) with below Matrix as output which showing summation of Amount based on Type and Year. 

Now, My further requirement is :

1- To implement Range filter that holds values like (<25%; 25-50%; 50-75%; 75-100%).

Lets say, User has selected Type=Credit and Range<25%, only records where Percenatge is <25% for Type=Credit will be considered as output

Data will be available after Type=Credit and Range<25%, will be as shown below

Now, next step would be generate the data for all the Type and available year for these three Projects (for which above data is available after filteration) and then create Matrix based on that data.

I.e. need to have data for all the projects (P-1, P-2 and P-3) for Year (2017 and 2018) for all the Type, as shown below

Then Matrix will be created as shown below 

Note : If there is another filter say Channel=1, then Range will be applied on the data left after filteration of Channel=1 and then rest of the procedure will remain same.

Please suggest!!

Thanks

Amit