Change colour of header and values to different colours

[JemmaD]

Hi there,

I have a table and I want it to look as close to the below format (not Power BI) as possible.

I know how to change the header OR the values, but it doesn't seem to allow me to do different things for both. 

Is there a way I can apply different colours and formats to both Header and Values in a table?

[Anonymous]

Hi @JemmaD,

I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.

Thank you,
Pavan.

[Anonymous]

Hi @JemmaD,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly "Accept  as  Solution" and give it a 'Kudos' so others can find it easily.

Thank you,
Pavan.

[Anonymous]

Hi @JemmaD,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept  as  Solution" and give a 'Kudos' so other members can easily find it.

Thank you,
Pavan.

[AnkitKukreja]

Hi! @JemmaD 

You can change the colors for headers and then use Specific Column settings and change the color for columns.

Afaik, the headers color can't be changed individually.

[JemmaD]

@AnkitKukreja thanks I ended up doing this, how frustrating. Also, because I want to centre the text, but I am unable to do that when I apply a format only to the header. 

I ended up using Cell elements background colour and placed the same colour in highest and lowest gradient 

[Anonymous · Accepted solution]

Hi @JemmaD,

Thanks for the update and great job finding a workaround!

1.In Power BI, you can format headers and values separately, but header formatting (like alignment and color) applies globally, not per column.

2.Center-aligning header text individually isn't currently supported.

3.Your approach using Cell elements and setting the same min/max color in conditional formatting is a smart workaround for controlling background color consistently.

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.

[pankajnamekar25]

Hello @JemmaD 

That is true no such option available

you can try for workaround like custome visual 

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.