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

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.

Reply
Ethanhunt123
Helper III
Helper III

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.