Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Is there any update on this question ? I want same output

 

KNP's avatar
KNP
Super User
4 years ago

I'm not sure replying to a post from 2017 is going to get you the best answer but I'll post this here in case it helps.

The basic pattern I follow is...

Create a measure with your rules that defines the colour you want. (adjust to suit your data)

Colour = 
VAR v =
    SELECTEDVALUE ( 'Table'[Column1] )
RETURN
    SWITCH (
        TRUE (),
        v = "a", "rgba(255,100,10,1)",
        v = "b", "rgba(10,10,255,1)",
        v = "g", "rgba(10,255,10,1)",
        v = "r", "rgba(255,10,10,1)"
    )

 

Right click on the value/measure in the fields of your matrix and select 'Conditional Formatting' >> 'Background Colour' (or whichever formatting option you want). 

Choose field value and your colour measure.

Hope this helps.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi KNP 
     Thanks for your quick reponse
    The requirement is I have to show color coding( Conditional Formatting) for the  Single row where I have dates ( in row  section ).Here the logic is the row (say project) which has the dates less than current date  I have to show RED color .
    Power bi facilitates  Conditional Formatting only for the values section.
    So I want color code for the sinle row in row section.
    Thank You KNP