How to color a specify column in matrix/table

[javieezy]

Dear all, 

This is how my matrix looks like. I would like to color the column "2C" always, no matter what the value is.

Conditional formatting only permits to apply based on inventory value (the numbers you see)

Appreciate your help. 

[v-kkf-msft · Accepted solution]

Hi @javieezy ,

Create measure:

color = IF(MAX('Table'[Block]) = "2C", "red")

Then set background color based on "color" field in advanced contrals.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

[sanjanarama]

@v-kkf-msft 
i tried same way for matrix data of mine and conditional formating is no longer valid if we expand the data. kindly help me out

Re: conditional formatting in matrix data - Microsoft Power BI Community


https://drive.google.com/file/d/1N8_8G0EGT0TLwvi1FeAJgD0AQ-WUK_gC/view?usp=sharing

[dkaushik]

Hi @javieezy ,

This can be achieved by using "Field Formatting". Make to you turn on "Apply to Header" and select whatever color you want as font and background.

Please mark as solution and give Kudos is it helps you.

Thanks,

Dheeraj