The ability to conditionally format a measure value based on another measure value is a very useful feature, especially when we want to highlight changes/comparisons between two measures.
Say for example we have created a budgeting report, and we would like to see whether the Actual cost has exceeded the Budgeted cost. We can then create two conditions using both of these values like for example:
If Actual Cost > Budget Cost; then color "red",
If Actual Cost < Budget Cost; then color "green”
This way we can know whether we have exceeded our Budgeted cost or not by simply inputting the values.
Currently Power BI does not support conditional formatting based on measure values, and instead only allows Rule based formatting for numeric values.
Inforiver lets you conditionally format one measure based on another measure. Let us illustrate this with an example:
1. In Home tab we select the Conditional Formatting tab, and under that dropdown we will select Create Rule option:
2. Next, we will select Rules (If Conditions) under the Format by dropdown:
3. Under conditions we will select Value. This will allow us to choose our conditions based on values as opposed to numbers:
4. Then we will select the value against which the condition will be applied:
5. Finally, when we click Apply, we can clearly see that our table has been formatted as per our given condition:
We can even create another rule using measure values:
