Forum Discussion
How do I apply conditional formatting to text column in a Matrix Visual?
powerbihelp87 , You can create a color measure . That return color
Color Date =
var _min =minx(allselected(Date,Date[Year])
return
Switch( true(),
FIRSTNONBLANK('Date'[Year],year(TODAY()))-_min =0 ,"lightgreen",
FIRSTNONBLANK('Date'[Year],year(TODAY()))-_min =0 ,"blue",
"red")
if(FIRSTNONBLANK(Table[Col1],"ABC") "ABC","green","red")
You can use that in conditional formatting after choosing the field option. and use this measure.
refer
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 the help but I dont know if this will help conditional format my "rows" in the matrix?
0
powerbihelp87 , color measure needs to be used only in conditional formatting. There is no row formatting, you have to format all column using same measures
amitchandak I do want the entire column to be formatted but in a matrix it is in the "rows" area even though it is a column. Once I try to click the field in the visualizations pane there is no option for conditional formatting in matrix. in a table the option is there
ElisaT this is the question I asked, not sure if any of these answers will help you
A work around I am going to use is possibly have a symbol and then the text field. This way it stands out somehow.