Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
Shawn,
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'm wanting to do this in a Matrix, sorry for not mentioning it before.
I believe that both Table and Matrix visualizations have cell conditional formatting now, definitely tables.
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-conditional-table-formatting/
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.
Total Coats:=SUM(Table1[Coats]),
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.\
User | Count |
---|---|
123 | |
76 | |
62 | |
50 | |
49 |
User | Count |
---|---|
175 | |
125 | |
60 | |
60 | |
58 |