How to change format / style of column headers

[Eva1]

Hi,

I have set up a table via BI but i would like to change the header of each column to be centred and a different colour?  Is this possible or have i taken an unecessarily long way round to do this.

[nouheerbabu]

You can change it from "Visuals", go to "Specific Column" and select only "Apply to header"  and change the format from Values.

[Eva1]

Hi Alexis

So i have the table, then i clicked the three dots in the top right hand corner and this appeared.  Its headed Main, Outer header/border, reusable styles, header row, columns, rows.  I presume i need to write some code to adjust the colour of the header?

[AlexisOlson]

This doesn't look like anything from within Power BI Desktop to me unless it's from some custom visual. If it's a custom visual, you'll need to refer to the documentation for that visual if it has any.

[Eva1]

Alexis - i think ive sat here for 3 hours looking at this and you are right, its a custom visual called 'summary table' when actually i just amended it to 'table' and looks fine!  ARGHHH.

Is there any way to format specific rows here to amend to % format?

[v-angzheng-msft]

Hi, @Eva1 

It may be helpful to use Switch or IF function, such as If(Max(RowName="A"),Value&"%", else)

refer:

https://community.powerbi.com/t5/Desktop/Creating-a-calculated-column-for-the-latest-and-previous-da...

Best Regards,
Community Support Team _ Zeon Zheng

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

[Eva1]

Hi, 

Do you mind explaining how to do this if and switch as this link doesnt appear to correctly show how?

Revenue

Cost of Sales

Profit

Profit Margin

And i would like the profit margin row to be formatted as a %.

I am new to BI so wanted to understand this at basic principles

[v-angzheng-msft · Accepted solution]

Hi, @Eva1 

The link above I used to show just one scenario with the Switch and Format functions
If you want to format as a percentage, you can select the column or measure you want to format and then click the percentage button at the top of the desktop.

Or you can format it to the format you want by using the FORMAT function.

FORMAT Function.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

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

[AlexisOlson]

Sorry. I don't know how that custom visual works.

[AlexisOlson]

I don't know what your screenshot is related to but if you have multiple fields in your table, then you can format them separately under the Field formatting section in the Format pane (note the toggle for whether to apply the format to header / values / total ).

If you have a matrix where your columns are a pivoted field, then I don't think you can control them separately.