Forum Discussion
Mixed alignment for headers & values in table with coloured headers
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
4 Replies
- wynhodgkissAdvocate II
sort of like thus
- FowmySuper User
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
- FowmySuper User
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 requiredExample
- wynhodgkissAdvocate II
Hi Fowmy , unfortunately that does not provide the ability to colour the headers individually.