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
Anonymous
Not applicable

Format color of 3 measure based on a column/attribute

Is there a way to set colors of texts in the measure values based on SSD?

Laedays_0-1634106020684.png

 

For example,

 

IF SSD is "Backlog" the 3 values ( Required Qty, On_Hand, Shortage) will be color Red 

IF SSD is "N5D" the 3 values ( Required Qty, On_Hand, Shortage) will be color Blue

 

is that possible? 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , you have to do conditional formatting for each value column in matrix

 

But you can use measure like 

Color  =

Switch( True() ,

[SSD ]=  "Backlog", "Red",

[SSD]= "N5D", "Blue",

"green"

)

 

And use this in conditional formatting using the field value option

 

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , you have to do conditional formatting for each value column in matrix

 

But you can use measure like 

Color  =

Switch( True() ,

[SSD ]=  "Backlog", "Red",

[SSD]= "N5D", "Blue",

"green"

)

 

And use this in conditional formatting using the field value option

 

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

Anonymous
Not applicable

this is what i want to achieve @amitchandak 

RED for Backlog

Blue for N5D

 

And so on

Laedays_0-1634106685031.png

is that possible to do in PBI?

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.