Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
wynhodgkiss
Helper III
Helper III

Mixed alignment for headers & values in table with coloured headers

Hi all,

I am trying to produce a table like the below:

MonthTargetSales%
August 2022£1,000£1,20020%
September 2022£2,000£2,20010%
  • 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 4
Fowmy
Super User
Super User

@wynhodgkiss 

Apply alignments as follows,

For header: 

Fowmy_0-1661954412725.png


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

Fowmy_1-1661954479567.png

Example

Fowmy_2-1661954492401.png

 

 





Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

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

wynhodgkiss
Helper III
Helper III

sort of like thus

Screenshot 2022-08-31 145223.png

@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

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.