Conditional Formatting for String Value

Power BI
1

I have PowerBI report that I would like to do some conditional formatting on the “ShipVia” column highlighted. I would like the background or text of the ShipVia field to change colors based on the below logic

Dayton = Yellow
Fedex = Green - Anything that has Fedex in the description actually.
Pickup = Red

***I do have conditional formatting on the ShipVia total records already to not display the header text which I need to have still. Basically I just have the font set as black which is the same as the background.

Let me know if you have any questions, thanks!!!

image
image1920×1037 140 KB

WarehouseAvailabletoShip.pbix (792.9 KB)

2

@Preston ,

Try this - Use whatever conditional formating rules on font you are using to blackout the total. Then conditionally format the background using this measure and the Field Value conditional formatting option.

CF Shipvia = 
SWITCH( TRUE(),
    CONTAINSSTRING( SELECTEDVALUE( SO_SalesOrderDetail[ShipVia] ), "PICKUP" ), "Red",
    CONTAINSSTRING( SELECTEDVALUE( SO_SalesOrderDetail[ShipVia] ), "DAYTON" ), "Yellow",
    CONTAINSSTRING( SELECTEDVALUE( SO_SalesOrderDetail[ShipVia] ), "FEDEX" ), "Lime Green",
   BLANK()
   
   )

image
image1050×464 61.8 KB

  • Brian
1 Like
3

thanks so much! This worked perfect!!

1 Like