Forum Discussion
Conditional Formatting based on Brand name
Hi, I have a table with Brand Names in rows and Dates in columns. There are around 30 brands, and new ones can be added along the way. In the table if the brand exists in a certain date, it is ma...
Hi Anonymous ，
I created a sample pbix file for you(see attachment), please check whether that is what you want.
1. Create a measure to get the related color under different brand
Conditional formatting = CALCULATE ( MAX ( 'Fontcolor format'[ColourHex] ), FILTER ( 'Fontcolor format', 'Fontcolor format'[Brand] = SELECTEDVALUE ( 'Table'[Brand] ) ) )2. Create a matrix and set conditional formatting for Values field as the below screenshot
Best Regards
Hi Anonymous ，
I created a sample pbix file for you(see attachment), please check whether that is what you want.
1. Create a measure to get the related color under different brand
Conditional formatting =
CALCULATE (
MAX ( 'Fontcolor format'[ColourHex] ),
FILTER (
'Fontcolor format',
'Fontcolor format'[Brand] = SELECTEDVALUE ( 'Table'[Brand] )
)
)2. Create a matrix and set conditional formatting for Values field as the below screenshot
Best Regards