Conditional formatting (cell highligh, font, etc) when comparing multiple fields

[Beth_Schwenzfei]

PowerBI needs to have the ability to offer conditional formatting of based on the comparison of 2 or more metrics. For example if metric A = metric B then change the font and highlight color of the cell to red. If metric A > metric B and metric A < metric C then change the font and highlight color of the cell to green. This should be unlimited for how many colors can be used. Other BI tools offer this feature. Note that this is different than what PowerBI currently calls ‘conditional formatting’

[Srilakshmi_C]

Setting font color conditionally based on values of other column would be useful request.. alternatively, there can be option to write expression for formatting the cell/column (currently there is cell format is based on the value of the cell)

[john_ashley]

I'm quite happy to do the comparison in a different column (probably hidden) and format based on that value. What ever is simplest to get this EXTREMELY valuable feature started, especially since the Nov 2017 update.

[toonnycoulier]

what's up Doc. 😉 ? 14 pompondertjes is exalle to 15 kiloWhatt's ? ° blub plonsh the sun reflected on water .....

[vlassauw]

You can start with a somewhat primitive workaround like SSRS uses: Allow report level code and report field background/foreground propery to allow user enttry expression that references this code and returns proper colour depending on what report level code returns, i.e. analyze how it works in SSRS and implement. Omitting proper conditional formatting based on other columns of various data types is probably a deal breaker for my company as we are migrating to Power BI existing reports in SAP BO that has extensive formatting possibilities. I rebuild some of them in SSRS and got it to work, but if I have to rebuild them in Power BI and users lose all conditional formatting because 90% of conditional formatting in my existing reports is not surported in Power BI. Please make this functionality a priority. The November 2017 update was an improvement but unfortunately not enough to make it usable in my case.

[danlopre1]

8 months, 1,233 votes later and still no reply. Are we ever getting this or should we give up?

[jfranck_clarity]

totally agree

[gorzkowskib]

Go spaceX! Need this por favor.

[nasir85shaikh]

Waiting for this feature for long time

[sudheerch161]

i agree

[tejas_modi]

We need to have this, to have table cell color coded based on comparison with other field, currently there is no functionality. Must required in Power BI.