Mixed alignment for headers & values in table with coloured headers

[wynhodgkiss]

Hi all,

I am trying to produce a table like the below:

Month	Target	Sales	%
August 2022	£1,000	£1,200	20%
September 2022	£2,000	£2,200	10%

• The % field is displayed as an icon based on the %. The default alignment is right (not very logical for an icon)
• For the headers, centre alignment was selected via column headers formatting. For visual purposes, the headers have beem given background cell colours using specific column formatting. 
• This seems to take precedence over the column headers formatting so I am unable to force the alignment of the % column into centre without also formating said column in colour as per the header.

Is there any other way to format headers and values independent of each other? The options seem incredibly limited having used tableau much more extensively over the years.

If this can't be achieved in standard functionality but can be done by creating a custom theme, any advice on doing so would be much appreciated.

Edit: Not being able to present a table in this post is a bit useless isnt it?

Headers are aligned centre

Month values aligned left

Target & Sales values aligned right

% values aligned centre

[Fowmy]

@wynhodgkiss 

Apply alignments as follows,

For header: 

For values, Select Specific Column option and turn off Apply to Header and turn Apply to value as required

Example

[wynhodgkiss]

Hi @Fowmy , unfortunately that does not provide the ability to colour the headers individually.

[wynhodgkiss]

sort of like thus

[Fowmy]

@wynhodgkiss 
Unfortunately, it's not possible yet, please vote for the idea that has been created to have this feature implemented.

https://ideas.powerbi.com/ideas/idea/?ideaid=a7c9b8d6-7148-454f-b495-4d9871f79ce8