Forum Discussion
Conditional formatting for multiple columns with text values and numbers
Anonymous , Create a measure like this . And use that with field option under conditional formatting
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"
)
refer Color Measure - Conditional formatting
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
amitchandak, thanks for quick reply.
Not sure if that measure will help to highlight cells, containing "R".
All examples in web I saw, contains only 1 column, where cells could be highlighted based on their values. Is there a way to do it for miltiple columns in 1 batch? I have weeks year to date, which will be constantly updated.
I have no issues to make this in vba in excel, but moving thisng to PBi create difficulties...
Thanks