topic Re: How to insert an additional header row in a table? in Custom Visuals Development Discussion

How to insert an additional header row in a table?

colin_sutton — Tue, 18 Feb 2020 04:22:52 GMT

I'm setting up a report in PowerBI, trying to match the formatting of an existing report, but can't see how to insert text in or over my column headers:

The header should look like:

Name | ID | Date of Birth | Sex |

| | dd | Mon | YYYY | |

(where the column names are coloured)

It's simple to do this in excel, but I can't see how to do it in PowerBI.

Re: How to insert an additional header row in a table?

Anonymous — Tue, 18 Feb 2020 10:28:46 GMT

Hi,

I think you can just use a textbox and write a custom text in there and add it in the place you were looking for. It is there in the Home --> Insert (right above image). May be that will help?

Regards

Re: How to insert an additional header row in a table?

colin_sutton — Wed, 19 Feb 2020 08:54:15 GMT

Do you mean like this, with text boxes above the table? It is hard to get the columns to line up and the borders don't match.

Re: How to insert an additional header row in a table?

colin_sutton — Mon, 09 Mar 2020 06:33:01 GMT

@Anonymous So, I guess it's not possible without writing a new visual?

Re: How to insert an additional header row in a table?

Anonymous — Mon, 09 Mar 2020 07:23:37 GMT

Hi Colin -

I am sorry for that... yes, I believe we may need to have a custom Visual created for it or wait for PowerBI to come up with a solution later on. You can try suggesting a new idea for this one. I am sorry again for not being able to solve this for you.

Regards