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
jeongkim
Helper V
Helper V

Value color customization

Hi all,

 

jeongkim_0-1670819050687.png

 

Can I add brackets () and +- 

 

e.g.

(+3.5%)

(+0.15)

(-2.7%)

(-4.76)

 

jeongkim_0-1670819636254.png

and can we change the color for this arrows? 

e.g. upward = Green

Downward = Red

 

jeongkim_0-1670821599917.png

and reverse this,, 

Green down triangle

Red up triangle

 

PBI Matrix doesn't seem to have value color customization? 

so anyone knows how to make DAX for this pls share with me and very would be appreciated. 

 

 

jeongkim_0-1670818647614.png

 

 

 

2 REPLIES 2
VijayP
Super User
Super User

@jeongkim 

to get () parentheses you must use Foramt function on top of your measure

to get different colors arrows  there are inbuild arrows while using icon sets in conditional formatting




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


can you give me the example of the measure? in excel I can put it in but in Power bi, it seems the function is a bit different?

and there's no other color of arrows in conditional formatting so I would like to customise it. 

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.