Coloring column Help

[Anonymous]

Hello everyone,

Hope you are well,

I would like to change the color of these specific columns. As you can see it is divided by "Period" and "Comparison" 

I want to change the back ground values for "Comparison Column" 

Is it possible?

Thank you,

[Anonymous]

Hope you are well,

I would like to change the color of these specific columns. As you can see it is divided by "Period" and "Comparison" 

I want to change the back ground values for "Comparison Column" 

Is it possible?

Thank you,

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

As tested, conditional formatting and field formatting can't apply to the columns which are added into "column" bucket, it can work for "value".

As a temporay workaround, i insert a rectangle shape on to the matrix, then click both the shape and matrix to add them into a group.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , You can create a color column with the condition and use that in conditional formatting after using "Field Option"

Refer

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values