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
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors