Conditional formatting on a drill through list

[Jo_Harrison]

I want to highlight values in a list which are of more interest than others. But I don't seem to be able to use drill through and conditional formatting in combination.

Example - I have a list of processes (P1, P2 etc) which are each linked to a combination of data types (A,B,C,D,E,F,1,2,3) these data types are split into two categories - as denoted here by the letters / numbers.

 I have built a sucessful drill through where I select a process and then go to a detail screen which shows me the list of associated data types - i.e. I select P1 and get data types A,D,3 - all great so far

I then want to highlight the difference in category so it stands out in the list something like A,D,3 However when I apply conditional formatting to my list Power BI seems to ignore the initial drill through reference and give me the whole list - so I get A,B,C,D,E,F,1,2,3   

Is there any way I can highlight just items in my drillthrough list to get the result A,D,3

Thanks in advance

Jo_H

[v-yuta-msft]

Hi Jo_Harrison ,

Drill through can't affect the result of conditional format. To achieve your requirement, you should use a slicer instead.

Regards,

Jimmy Tao

[Jo_Harrison]

I already use a slicer

step 1 - use a slicer to produce a filtered list of processes which contain a particular data type

step 2 - using a drill through I look at the details of the selected process - which shows me (amongst other things) the other data types associated with my process

It is this second (drill through) list that the conditional formatting affects as described in my original post.

The conditional formatting affects the drill through result.

Jo_Harrison