Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , make sure this table it joined with brand you are using or part of the brand table

 

create a measure max(brandcolor[ColourHex]) and use that is conditional formatting using field value option

 

 

or measure like

 

maxx(filter(brandcolor, brandcolor[ColourHex] =max(Table[Brand])),brandcolor[ColourHex])

 

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