Conditional Column Formatting in Column Chart

[Marac0105]

Hi all,

Is there a possibility to conditional format columns in column chart based on slicer selection?

Thanks in advance for all your help.

[v-cherch-msft · Accepted solution]

Hi @Marac0105 

Yes,you may check below sample file.Create a measure and use it as rule in conditional formatting.

Measure = 
IF (
    SELECTEDVALUE ( Table1[event] ) = "event1"
        && SUM ( Table1[value] ) > 5,
    1,
    IF (
        SELECTEDVALUE ( Table1[event] ) = "event2"
            && SUM ( Table1[value] ) > 3,
        2,
        IF (
            SELECTEDVALUE ( Table1[event] ) = "event3"
                && SUM ( Table1[value] ) > 2,
            3
        )
    )
)

Regards,

[Marac0105]

Hi @v-cherch-msft 

Thanks a lot for your help, it helped me.

Regards