Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
I am using DAX to show up green arrow but my total is in black. How can I color my total arrows as well?
Hi @Ethanhunt123 ,
You can set the color of the Total of "Arrow Payroll Expense" by selecting Field Formatting Option of that table --> then Select the Name of the Column/Field(i.e. Arrow Payroll Expense) --> Change the Font color accordingly. (Screen shot is attached for your reference)
Please give Kudos and Accept this as a solution if it helps you!!!
Arrow can be in red as well, it is dynamic based on my Actual and Expected amount.
I cannot set an arrow to one color from field formatting
Hi @Ethanhunt123 ,
Sorry for that, Unfortunately, the conditional formatting does not apply for the subtotal and total in current release desktop. Here is a similar idea, you could click to vote it up: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17401381-conditional-formatting-f...
Please also refer to the simiar threads:
https://community.powerbi.com/t5/Desktop/Conditional-Formatting-on-Total-and-Null-Values/td-p/313725
Best regards,
you can use the Conditional Formatting option of the table to set the color of your icon as per condition.
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 56 | |
| 41 | |
| 39 | |
| 22 | |
| 21 |
| User | Count |
|---|---|
| 144 | |
| 106 | |
| 64 | |
| 38 | |
| 31 |