Forum Discussion
Conditional formatting specific cells in a table
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
Hi Derek,
Conditional formatting is very basic in Power BI so please put a Vote for the following idea:
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.
4 Replies
Hi Derek,
Conditional formatting is very basic in Power BI so please put a Vote for the following idea:
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.
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
- See if this idea is of any help. https://youtu.be/VIYJ8YM2huQ
