Forum Discussion
Solved
conditional background color
Hi, I have a field (data type text) called test that has some rows with Y and other empty I need to color the rows in a table with yellow color if the field test is Y and white if it's empty. I d...
Giada_Togliatti , you can create a color measure and use that after selecting field option
example
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" )https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692
Change the values of the "Y / Blank" to "1 / 0" then apply a conditional formatting on each column you want formatted.
Use the "based on field" together with format by rules.
Br,
J