Change color for bar chart into the measure not in conditional formating

[VagelisVlachos]

Hello.

I have this measure that shows in one bar chart the top10 and bottom 10 of customers by profit.

I want to change the color in the measure for a bar chart when its >0 to green and when its <0 to red.From the conditional formating it goes wrong cause the top 2 is green and all the other are going red.

Please help!

Top/Bottom =

VAR top10 =

    RANKX ( ALL ( DimCustomer[Name] ), [Gross Profit],, ASC )

VAR bot10 =

    RANKX ( ALL ( DimCustomer[Name] ), [Gross Profit],, DESC )

RETURN

    IF ( top10 <= 10 || bot10 <= 10, [Gross Profit], BLANK () )

[FreemanZ]

hi @VagelisVlachos 

RANKX relies on filter context. How does you visual look like?

[VagelisVlachos]

[VagelisVlachos · Accepted solution]

Change Qty Color =

VAR PDDate =

     ( [Gross Profit])

RETURN

    IF ( PDDate < 0, "#861B14","#499277")

You make this a measure and after you make a conditional formating into "bars" and you pick this in the "What field should we base this on"