Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a matrix visualization as you see in the screen shot below
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.
Solved! Go to 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.
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
The "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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
105 | |
88 | |
73 | |
66 |
User | Count |
---|---|
124 | |
113 | |
98 | |
80 | |
72 |