Requesting Help to Calculate Multi-Level Fail Rate on a Line Chart+Slicer Combination

Hello,

I have a set of data that looks like the one I have pasted below.

Data - 

There are two regions - R1 and R2. And each region has three groups - R1 has G1, G2, G3 and R2 has G4, G5, G6.

Then, there are Volumes and Fails for each date-region-group combination, from which the Fail Rate is calculated (Fail/Volume).

My requirement - 

I need to show the Fail Rate on a Line Chart.

It should only show the Fail rate for each date. Then, there would be two slicers for region and group.

So,when I select R1 in the region slicer, then the chart should show the Fail Rate for R1. If I select G5 in the Group filter, then the chart should show the Fail Rate for G5.

Challenge -

The challenge that I am facing with the below data is that, when I represent this on a Line Chart, and then put in a slicer and select R1, then it sums up the Fail Rate, which is incorrect.

How can resolve this? 

As explained, I need the original view as only date-wise Fail Rate and as and when slicers are selected, then those rates should pop-up.

I know, I can calculate three separate fail rates, one for Date-wise, one for region-wise and one for group-wise, but then I will have to put that into three charts and not one.

I hope my explaination makes sense.

Any support will be much appreciated.

Thank You so much. 

Thank You