Forum Discussion
Change background colour for table data
Hi lee-martin ,
1.You could use the following formula to create a measure and the apply it to Conditional Formatting:
Color Measure = SWITCH(MAX('Table'[Column1]),"yes","Green","no","Red","not yet","#FFBF00","not necessary","Yellow")2. Go to Format pane-->Disable "Total" to not show total field:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
lee-martin , You can create a color measure with column or measure or with both. And use them in conditional formatting using field value option
Color Year = if(FIRSTNONBLANK('Table'[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))
Color = if(FIRSTNONBLANK('Table'[Year],2014) <=2016 && AVERAGE(Sales[Sales Amount])<170
,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))
Color sales = if([Sales Today] -[sales yesterday]>0,"green","red")
color =
switch ( true(),
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity1" && sum('Table'[Value]) >500,"lightgreen",
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity2" && sum('Table'[Value]) >1000,"lightgreen",
// Add more conditions
"red"
)
How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4
I've now managed to do this with a column - however it's added a row for "total" at the bottom which I really don't need. Is that easy to remove? (it's not easy to google it)