Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Is it possible to do conditional formatting in tables with more complicated fields than just "lowest & highest value" ? For instance you have two columns in a table, one having the sales for January and the other the sales for February and the rows are the different brands : I would like to highlight in the column February Sales the fields that are lower to February Sales. How would I do that?
Same logic for a graph: if you have a clustered column chart with 2 month and want to highlight when it's decreasing/increasing from one month to the other, how would you do?
Any ideas?
Thanks!
Hi @sophie63,
As conditional formatting only support a static column, I'm afraid your requirement can't be achieved currently. You can vote on this similar idea: Dynamic conditional formatting.
Best Regards,
Qiuyun Yu