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 associated numbers to format text values.
An example would be for part1, it shows up twice in the table with values 3 & 1 so it has an avg value of 2, part2 is has 2 & 1 so its avg is 1.5, and part 3 has an avg of 3. What would be the best way to take the average of numbers in column 4 to conditionally format values in column 3. I would like to do this for every column in a bigger data set so I want to avoid making new columns to store associated averages.
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.
8 Replies
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.
The problem is if I want to conditionally format the vals, it doesn't take the average of the sets of values since the part column is different for val4. It takes the average value seperately for each instance of val4.
In this case the columns are being formatted by the average value of the hardiness cloumn. It shows tree as having two seperate avg values and seed as having seperate avg values. How could I get all similar values to have the same average
Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.