Adjust Column Colors

[rafamorim87]

Good morning

Could anyone help me with this question?

I need to build the table graph so that the largest and smallest values ​​are highlighted with the color I enter and the other columns are highlighted in the color I choose.

I almost managed to do it, but the other columns are blue. And I need to change this color.

I included the assembled graphic in the image, the rules for the colors I created and the measurement I'm using.

I need to change the blue color of the columns, would it be possible?

Thank you in advance.

[Ritaf1983 · Accepted solution]

Hi @rafamorim87 
You can create all the colors logics with dax ,
For example :

Bar color =

var min_value = CALCULATE(minx(SUMMARIZE('Table','Table'[Team],"_sum values",sum('Table'[values])),[_sum values]),ALLSELECTED('Table'[Team]))

var max_value = CALCULATE(Maxx(SUMMARIZE('Table','Table'[Team],"_sum values",sum('Table'[values])),[_sum values]),ALLSELECTED('Table'[Team]))

Return

SWITCH(TRUE(),

sum('Table'[values])=min_value,"Yellow",

sum('Table'[values])=max_value,"green",

"black")

** The color can be In hexacode 
and then just take this measure as a field to conditional formatting :

the pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly