Power BI
CompletedConditional formatting (cell highligh, font, etc) when comparing multiple fields
on 24 May 2017 19:48:36
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’
Administrator on 09 May 2018 05:39:06
As of our May release, you can now conditionally format a column by another field. Which means you can create a column that does your comparisons and then use that to format anything in your table or matrix. If you have other suggestions for conditional formatting options, make sure to vote on those as well! https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/#conditionalFormatting
- Comments (88)
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
Waiting for this feature for long time
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
Go spaceX! Need this por favor.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
i agree
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
totally agree
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
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.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
8 months, 1,233 votes later and still no reply.
Are we ever getting this or should we give up?
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
what's up Doc. ;-) ? 14 pompondertjes is exalle to 15 kiloWhatt's ? ° blub plonsh the sun reflected on water .....
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
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.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
I cannot understand why such a basic function in excel is not in power BI. This would be so useful
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
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)