Conditional formatting in matrix based on values

[NidhiBhusari]

I want to color individual rows differently based on the value in matrix (It's not alternating rows). Is that possible in Power BI?

Something like this - 

Any help would be highly appreciated!

[amitchandak · Accepted solution]

@NidhiBhusari , If this is a single measure, the color scale option should do conditional formatting in the matrix.

If you want only few colors you can use color measure

1) Try Color Scale

2) Try Field formatting using a measure

example

Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")
Color Year = if(FIRSTNONBLANK('Table'[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))

refer if needed

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://www.youtube.com/watch?v=RqBb5eBf_I4