Conditional Formatting Option Does not Appear

[MontherKH]

I have a matrix visualization as you see in the screen shot below

the matrix

I am trying to format the column "Product Type" To change its background color to red if it has a negative "Average of Gross Profit per Serving", but as you see in the screen shot below, the option for Conditional Formatting does not appear.

[Shaurya]

Hi @MontherKH,

Go to Cell Elements in the Formatting Pane and turn on Background Colour and Font Colour option. You'll be able to conditionally format you values then by using rules or measures.

Did I answer your question? Mark this post as a solution if I did!
Consider taking a look at my blog: Forecast Period - Previous Forecasts

[MontherKH]

The "Product Type" Column that I want to format does not appear in "Cell Elements".

[v-jingzhang · Accepted solution]

Hi @MontherKH 

Currently conditional formatting is only available for Values fields in a Matrix visual. It is not supported for Row and Column headers. This is why "Product Type" column doesn't appear in "Cell Elements". 

You can vote up the following ideas about this requirement:

Microsoft Idea: Conditional Formatting of Row Headers in Matrix

Microsoft Idea: conditional formatting

Microsoft Idea: Conditional Formatting for Matrix Headers

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.