Table with colour coding

[morgancampbell]

I'm looking to create a table with our employees and their statistics and I want each box to be colour coded (red/green) based on how much percent higher or lower it is compared to the last week. How would I go about doing this?

[amitchandak]

@morgancampbell , Create a color measure and use that in conditional formatting with "Field Value" option

Color Measure =
var _avgDisc = CALCULATE([Percent %],ALL(Retail))
return switch(TRUE(),
[Percent %] <_avgDisc , "Red",
[Percent %] >_avgDisc , "Green", "Black")

In case you need steps

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

[Greg_Deckler · Accepted solution]

@morgancampbell Use conditional formatting:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

[morgancampbell]

That's brilliant, thank you.