Forum Discussion
Conditionally Formatting text values based on multiple associated numbers
You can do this entirely in the Power BI user interface. Use an implicit measure to show the average, and the same to create the conditional formatting. See attached.
Anonymous Something like this?
see attached.
Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
So I realized that it is just taking the average of the hardiness in a row, rather than the hardiness associated with the values. I want it to take the average value of the hardiness for all entries with value "maple" which would be 5 and format the cells with the value maple as green. Then all the values "bush" should have an average of 7.5 since the azelea bush has a hardiness of 6 and the holly bush has a hardiness of 9. I want it to take the average of all the similar values in a column, not just take the average of the exact same entries. Currently since there are two entries of "golf" "grass" "seed" it is taking the average of those 2 entries. I want it to take the average of every entry with "golf" (6), and seperately all the entries with "grass" (5.66), and "seed" (4.14) and format accordingly.
all columns are conditionally formated based on the hardiness row
expected results (yellow 9-6.5) (green 6.49-3.51) (blue 3.5-1)
data
| Species | Plant | Type | Quantity | Hardiness |
| holly | bush | leaf | 2 | 9 |
| maple | tree | leaf | 3 | 9 |
| iris | flower | bulb | 3 | 7 |
| azelea | bush | leaf | 10 | 6 |
| oak | sapling | seed | 6 | 6 |
| wild | grass | seed | 8 | 5 |
| ginko | tree | leaf | 5 | 4 |
| golf | grass | seed | 3 | 3 |
| oak | tree | seed | 3 | 3 |
| rose | flower | bulb | 6 | 3 |
| ginko | tree | seed | 4 | 2 |
| maple | sapling | seed | 2 | 1 |
| golf | grass | seed | 3 | 9 |
You have two rows for golf-grass-seed . Please indicate what the hardiness should be - 3 or 9 ?
Does the Quantity have any meaning? If so - please describe it.
Use 3 for the golf grass seed. The quantity is just used for a weighted average calculation seperate from this.
Anonymous Something like this?
see attached.