I am working on a report that shows our current inventory and our minimum on hand inventory quantity. If the current inventroy is lower than what our min is then I want to highlight these records in red. I have watched a few videos that suggest creating a measure that looks something like this:
You can create a calculation that outputs different values based on business logic conditions you select. Creating a formula is usually faster than creating multiple rules in the conditional formatting dialog.
For example, the following formula applies hex color values to a newAffordability rankcolumn, based on existingAffordabilitycolumn values:
To apply the colors, selectBackground colororFont colorconditional formatting for theAffordabilitycolumn, and base the formatting on theField valueof theAffordability rankcolumn.
The example table withAffordabilitybackground color based on calculatedAffordability ranklooks like this:
You can create many more variations, just by using your imagination and some calculations.
Thank you for the quick response @ribisht17 . I am trying to follow along with what you are saying but anything you might have posted after the ":" did not post. I am unable to see the formula and the example that you were able to provide. I am using the link you have also added.