Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

0
Shineccx007

How to show conditional format in table compared two column value

Submitted by Helper I on ‎01-17-2024 01:11 PM

I have a column[Safety qty] and a column [Inventory On Hand], now they are in one visual, I wanted to show"Red" color as alert when the value in [Inventory On Hand] is smaller than [Safety qty], what shall I do?

 

The conditional format didn't allow me to compare these two column directly.

 

Shineccx007_0-1705525786850.png

I am not able to get the Satety Qty column.

Shineccx007_1-1705525859801.png

Anyone can help?

 

Thanks!

Status: Delivered
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎01-17-2024 10:49 PM

Hi @Shineccx007 ,

 

I made simple samples and you can check the results below:

vtianyichmsft_0-1705560464673.png

vtianyichmsft_1-1705560533269.png

 

 

You can compare the size of the two by using a column of calculations, where true is 1 and false is 0, and then by using rules rules.

 

Best regards,
Community Support Team_ Scott Chang

Idea Statuses