Forum Discussion

rafamorim87's avatar
rafamorim87
Frequent Visitor
2 years ago
Solved

Adjust Column Colors

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.

 

Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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

     

1 Reply

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    2 years ago

    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