How to show a different colour for column A

[jacquelineq]

Hi,

I have a bar chart and I would like to display column A in red if the value is below column C and green if the value is above column C. How can I achieve that as the colour settings only show 1 option? 

[amitchandak]

@jacquelineq , if you are using legend , you can not. Use both axis and legend in the axis, and expand. Then Sort on axis and concatenate the label off. Post that you can do conditional formatting 

refer with conditional formatting code:Concatenate Label off : https://youtu.be/QgI0vIGIOOk

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...

[jacquelineq]

@amitchandak Thanks for your reply! 

May I know how should I code my measure to compare the values? This is my table:

Year	Scope	Type	Score
2021	A	Type1	80
2021	B	Type1	82
2021	C	Type1	84
2021	A	Type2	70
2021	B	Type2	73
2021	C	Type2	74
2021	D	Type1	81
2021	E	Type1	83
2021	F	Type1	86

[v-cgao-msft · Accepted solution]

Hi @jacquelineq ,

Please new a measure:

Color =
VAR _a =
    CALCULATE ( SUM ( 'Table'[Score] ), 'Table'[Scope] = "A" )
VAR _c =
    CALCULATE ( SUM ( 'Table'[Score] ), 'Table'[Scope] = "C" )
RETURN
    IF ( MAX ( 'Table'[Scope] ) = "A", IF ( _a < _c, "Red", "Green" ) )

Use it as a conditional format for the bar color.

result:

Attached PBIX file for reference.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data