topic Change color for bar chart into the measure not in conditional formating in DAX Commands and Tips

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

VagelisVlachos — Thu, 15 Dec 2022 21:56:45 GMT

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 () )

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

FreemanZ — Thu, 15 Dec 2022 22:01:24 GMT

hi VagelisVlachos

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

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

VagelisVlachos — Thu, 15 Dec 2022 22:31:43 GMT

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

VagelisVlachos — Thu, 29 Dec 2022 10:09:56 GMT

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"