Forum Discussion
Conditionally Formatting text values based on multiple associated numbers
I'm trying to figure out a way to format text values based on an associated number, but one text value could be associated with mutliple numbers. Is it possible to write a formula to take the AVG of ...
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.
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.
Yes! That looks right! Sorry for not giving enough enough information initially. Thank you so much