Is is possible to change color on text based on certain factors? As in the example below.
Item Q1 Q2 Q3 Q4
Coat 22 13 54 53
Shovel 30 5 15 25
I would like to change the 54 & 30 to bold or a different color to show the person viewing the report which Quarter was the best without really having to look through the row.
Conditional formatting can (just now) be applied to cell backgrounds in tables only - you can't use conditional formatting on cell text in tables, or on a matrix.
Your example looks like a matrix with Items and Quarters as columns, not measures. You can use conditional formatting of text in an R visual using geom_text() - see https://community.powerbi.com/t5/R-Script-Showcase/Heatmaps/td-p/68573 for a related example.
I believe that both Table and Matrix visualizations have cell conditional formatting now, definitely tables.
Hmm.. I just did the test and It is only supported in Table and not Matrix.
Ah yes, I remembering seeing it as started here:
Maybe end of this month?
You can use conditonal formatting feature but it is only supported in the table visual and with measures only. FYI- Microsoft has considered to make Conditional Formatting more rich and supported in other visuals in future releases.
For this, You need to create 2 measures.
Similarly for Total Shovels.
Create a Table Visual and Drag ITEM Field, Total Coats Measure and Total Shovels Measure as shown in the Screenshot.
As shown in the Screenshot, Select the drop down arrow of the Total Coats measure, and select conditional formatting.
It will pop up with a new dialog box as shown in the below screenshot.\
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.