Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |