Add Alert to highlight colors based on data in table

[BItoken]

Hi,

I have a requirement where i need to update a row color to red or green or orange based on a column which has 3 fields of high low and medium level. I it possible to do?

[v-diye-msft]

Hi @BItoken 

If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. If not, please kindly elaborate more. thanks!

[amitchandak]

@BItoken , You need to apply the condition of all the columns. Using that column or Create a color measure

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"))

And use that in condition formatting  on all the columns

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