Conditional formatting specific cells in a table

[jderekc]

Hi all,

First, I've read the following thread: "Is there a way to do a simple conditional format on a matrix?"

The solution doesn't really answer the question for the OP of that thread nor I.  I was wondering if there is a way to flag a cell in a table (or matrix--which doesn't seem possible to apply conditional formatting to) if it contains a certain value.  For instance: 0.  It would be great if I could do conditional formatting for values in column B to be yellow if they are less than their counterpart values in column A.

Basically if a sales order got posted for 1 quantity of a product and an organization could not fulfil it, thus leaving a total of 0 fulfilled, this should be conditionally formatted to be highlighted as a red flag of sorts.

Is this possible?

Thanks!

- Derek

 

[Anonymous]

See if this idea is of any help. https://youtu.be/VIYJ8YM2huQ

[Twilla · Accepted solution]

Hi Derek,

Conditional formatting is very basic in Power BI so please put a Vote for the following idea:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19385893-conditional-formatting-c...

The only way for you to get some kind of conditional formatting is to create an extra column (measure or calculated), there you could make a binary value based on B<A and set the color for that column. You could also subtract A from B and use conditional formatting on the resulting column. So concluding, it is not possible to do conditional formatting of one column, looking at another one.

[Anonymous]

Do you know if this has been updated in the new version? If not do you think you can explain for someone new to Power Bi how they would solve.

Store number  l Expected Online l Actual Online

1559                         4                            2

So I am trying to have the 2 or background highlight Red...Cell value Expected online < Acutal Online

[jderekc]

Thanks, Twilla!  I suspected as much.  I went ahead and voted for that idea and accepted your comments as a solution.  Have a great day!

- Derek