Forum Discussion
Conditional bacground color row header
Howdy,
I am trying to make an income statement and I tried to highlight some rows of it like EBITDA as shown in the image below. So far I got to do so with the values but I have not figured it out to do so on the row headers. This is a matrix visual.
Hi Anonymous
Currently Conditional Formatting only applies to Values fields, not Rows/Columns fields in a Matrix. So it is not supported to format the background color of row headers conditionally.
Regards,
Community Support Team _ Jing
3 Replies
Anonymous , You can create a measure like
if(max(Table[GYP_gestion]) = "EBITDA", "yellow", "white")
You can use the same in conditional formatting with field values option, You have to do conditional formatting for all columns, there is not row option
Conditional formatting the Pie Visual: https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
amitchandak I dont follow. Where is the option to set a condition for "Rows"?. The field I am trying to set a condition on is "GyP_Gestion".
Hi Anonymous
Currently Conditional Formatting only applies to Values fields, not Rows/Columns fields in a Matrix. So it is not supported to format the background color of row headers conditionally.
Regards,
Community Support Team _ Jing
