Forum Discussion
Conditional Formatting Doesn't Work with Drillthrough
Hi carolynhn25 ,
Refer to this document ,if the field the formatting is based on contains percentages, write the numbers in the rules as decimals, which are the actual values.
You can set it as shown in the image below.
(1)Set conditional formatting.
(2)Drillthrough across pages.
(3)Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous - Thank you so much for your reply!
I set the formatting rules to [if value>=0.00000001] and then tried the drill-through feature from the other page, but unfortunately some values of 0.00% are still showing (only after I drill-through). Does conditional formatting not work when using the drill-through feature?
Below is another screenshot of the view after using drill-through, as well as a screenshot of the drill through section on the right hand side of the report
Hi carolynhn25 ,
Refer to this document ,if the field the formatting is based on contains percentages, write the numbers in the rules as decimals, which are the actual values.
You can set it as shown in the image below.
(1)Set conditional formatting.
(2)Drillthrough across pages.
(3)Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-tangjie-msft - Thank you SO much! This worked perfectly!