cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

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

Super User

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors