0 Kudos

Conditional formatting by a different field does not work when there is a single value in the table

Status: Accepted
by Kamarto Visitor on ‎05-16-2018 08:03 AM



This new conditional formatting by a different field is a great feature but somehow it does not work when you have only a single value in the table. With more than one value the feature works perfectly fine when I apply color to Value field based on Value_vs_target (= IF(SUM([Value])>SUM([Target]), 1, IF(SUM([Value])<SUM([Target]), -1, 0))) following below rules:Conditional formatting rules.JPG


Conditional formatting table.JPG


The problem is that when I remove the Time field from the table, conditional formatting stops working as well.




Conditional formatting issue.JPG


I couldn't find any documentation about the limitations of conditional formatting so is this a bug or a limitation?


I would like to use single field tables with conditional formatting as KPIs since in the current KPI chart I'm not able to adjust the font size. I have already voted on the KPI customization (font size) idea https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15679131-kpi-customization-font-s... and hope it would be implemented as soon as possible so there would be no need to use these workarounds...


Status: Accepted
Idea Statuses