Adopt formatting from Excel

[tami]

Hello everybody,

I am facing a problem that I have not yet been able to solve in Power Bi Desktop yet. We have a table as shown below. There would still have to be inserted some background colorings. In the original Excel (from which the data is read in) these colorings would be already included, meaning it would be easiest for us if we could set that it should take over the formatting of Excel. If I have not overlooked anything in my research, this is probably not possible or do you have a tip for me?

Otherwise, of course, you could also insert the colorings in Power BI, but I haven't managed to do that yet. Specifically, it is about the fact that the respective value in e.g. column L is compared with the mean value (from the respective row) and if this value at L is e.g. 20% greater than the mean value, this value should be colored dark green. The same also for +10% in a lighter green and finally also for red colorings analogously (-10 and 20% of the row mean). The formula for the calculation would basically work in a nested if-condition I think, but I haven't found the right place for it yet and haven't managed to address the cell values (e.g. the 25 at L in row 2). Can you help me with this issue?

I have tested Conditional formatting with rules by taking the +-10/20% values from the Excel as limits for the coloring. But since the limits and the average value changes per row and I have not been able to enter the conditional formatting per row (only per column), it colors one row correctly and the remaining rows of column L, for example, wrong.

Order	kpi/item	L	M	N	O	P	R	Mean (per Row)
1	Key Performance Indicators
2	PI - TB	25	9	26	23	28	27	23
3	PI - T2B	60	55	50	54	57	53	55
4	Interest	68	73	64	66	74	69	69
5	Uniqueness	68	75	66	70	67	71	69
6	Brand fit	76	79	76	74	79	85	78
7	Credibility	77	76	70	71	72	77	74
8	Performance Dimensions
9	is something I like very much	59	59	57	55	51	56	56
10	is a high quality product	60	68	67	68	67	71	67
11	is new and innovative	61	60	61	64	63	61	62
12	makes me want to try it	59	60	59	59	62	57	59

Many thanks in advance!

[lbendlin]

You do conditional formatting based on field value, and point that to a measure that you compute according to your requirements. The result of the measure can be a numeric value range, or it can be an actual color name.