How to conditioanlly format the data in drill down using percentile

Hi,

My data is similar to:

My data is in matrix visual and is drill down (L1, L2, L3 are the rows in drill down and score and responses are columns).

Now I want to conditionally format the data (score and responses column) on the basis of percentile. The catch here is that the percentile should be determined only on the basis of the amount of data that we are showing at any point of time.

For eg:

If I drill further, the 25th and 75th percentile should be decided according to the drilled numbers and formatted accordingly

Now the percentile should be based upon only these 3 numbers. (The numbers are just made up. In actual, at an aggregated level, I am taking a weighted mean of score and responses to calculate the scores).

parry2k Cmcmahan po DAN npowerbi