Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
Ethanhunt123
Helper IV
Helper IV

UNICHAR in Totals

I am using DAX to show up green arrow but my total is in black. How can I color my total arrows as well?

2019-11-21_12-42-46.jpg

4 REPLIES 4
Tahreem24
Super User
Super User

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!!!

 

icon.JPG

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

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

https://community.powerbi.com/t5/Desktop/Matrix-Conditional-Formatting-Does-Not-Apply-to-Row-Subtota...


Best regards,

 

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

you can use the Conditional Formatting option of the table to set the color of your icon as per condition.

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! It's time to submit your entry.

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.