cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KMcCarthy9
Helper IV
Helper IV

Table Formatting - Centered Values, Different Color Column Headers

This seems like it should be doable, yet I cannot figure it out. 

 

I have a table with multiple columns. I would like to color the column headers in different colors according to their grouping AND I would also like to center the column header and the values. 

 

Under Formatting - Values, there is no option for alignment. Under Formatting - Specific Column there are the options for alignment and to assign a background color and choose to apply it to column header and values. I want the alignment applied to both, but color only applied to column header. 

 

Is this doable?? 

 

Thank you!! 

2 REPLIES 2
v-kalyj-msft
Community Support
Community Support

Hi @KMcCarthy9 ,

According to your description, I create a sample.

vkalyjmsft_0-1656913532340.png

Here're two columns. If you want to color the Column1 header and center the column header and values for both columns, here's my solution.

1. In the Formatting pane>Specific column, select Column2 in the Series box, turn on the Apply to header and Apply to values option, select black in the Text color and checked the Alignment.

vkalyjmsft_1-1656915038464.png

But for Column1, except the text color remains the same, the rest of the settings are the same as Column2.

vkalyjmsft_3-1656915444488.png

2.In the Formatting pane>Column headers>Text, choose the color you want Column1 to render, get the result:

vkalyjmsft_4-1656915679247.png

I attach my sample below for reference.

 

Best Regards,
Community Support Team _ kalyj

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

 

Hello, Thank you for the response, however I don't beleive this solves my issue. 

 

I am looking for the background color of the column headers to be different colors, not the text. I could use your method and switch out background color for text color, but the option under Column Headers assigns the same color to all column headers, when ideally I want to color them differently depending on the data source (ie first 4 columns - background red, next 6 columns - background blue, etc). 

Helpful resources

Announcements
Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Ignite 2022

What's Next at Microsoft Ignite 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Top Solution Authors