Centre Values in a table with different coloured headings

[BCWdesign]

Hi I want to be able to centre the values in this table 

In the formatting there doesn't appear to be an option to do so.

If choose a specific column this works but I can't then have a different heading to the values which I want white.

Seems simple but seems to be aluding me 🙂

[Ritaf1983 · Accepted solution]

Hi @BCWdesign 

Indeed, centering is possible only through the specific column format settings. It's not clear from the image you attached what you want to do with the colors, but if it involves cell content rather than headers, you might be able to use conditional formatting for the white color as the background you're talking about.

If you attach a link to a PBIX file with an example, I can check it more concretely.

P.S. It’s important to note that for easy reading of visualizations, centering may be confusing for readers. Best practice recommendations for table design are to align text to the left (including numbers that are read from left to right, such as order numbers or SKUs) including the header. For numbers, align them to the right so that units are under units, tens under tens, and so on. Similarly for icons used in conditional formatting (like numbers), so that the reader doesn’t have to constantly think about which direction to read.

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