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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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