Forum Discussion
Conditional Formatting Option Does not Appear
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.
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.
3 Replies
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 ForecastsThe "Product Type" Column that I want to format does not appear in "Cell Elements".
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.
