Hide header row in table visual and set column widths

[Anon9876]

I would like to set column widths in a table visual so that I can line up columns from 2 tables. Also I want to hide the headers for the second table so that it looks like one table. These are the two tables along with a text box, that I would like to line up with the data rows:

From searching the forums it looks like this is not possible in Power BI. I have seen various hacks for setting column widths and for removing the column headers the most popular way seems to be changing the font color and size. As far as I can tell, I can't set it below size 8, so that doesn't hide the row completely. What is the best way to hide the second visual column headers and get the 3 visuals to line up?

[danextian]

hi @Anon9876 

I wouldnt' follow your current route. Column headers cannot be entirely hidden - you can change the font size, color or replace the name in the visual with a space but they will still remain in the headers. It is also difficult to perfect align the column headers - while you can disable auto-resize, the problem is if the current width is not enough to accomodate and increate in the lenght of the figures, you will end up with either truncated or wrapped values. Instead, I would make use of calculation groups to apply the same time intelligence logic to different measures and a matrix viz that can be modified to look like a table

[alish_b]

Interesting!
First, the metrics don't seem to be dynamic so why not compute them in a disconnected table at refresh time? That will save you a lot of formatting (explained next).
Now into the world of workarounds. You could overlap the two visuals (maybe even rename the field titles of the bottom visual to '<Space>', remember this will mess up the width but that will be fixed next). Then, use the formatting option as below to determine the required length (which you will have to do for every measure/field and that does not stop there you will even have to revert them later)

Then head over to the Column header options for the visual and turn off Options>Auto-size width. This will ensure that the columns don't grow/shrink (messing up the illusion). Now revert the formatting options for the measures/fields to what they were before. ( I use this hack even in normal tables to get a consistent formatting.) That should do the trick (maybe you will have to mess around with the maintain layer order too in cases where the user clicks on the bottom table). But yes, if possible go with the first approach and save yourself from this formatting nightmare.

[Anon9876]

The formatting of the measures does seem to make it align much better than manually dragging the column edges. This may be a little bit picky, but is it possible to force column headings to wrap? Now that I have widened the columns to fit the reformatted measures, the second column header fits without wrapping, but it would look much better if it was wrapped as in my first screenshot. This is what it looks like now, before reverting the measures to the desired format: 

I have layered the visuals as suggested by v-hashadapu to hide the headers of the lower table visual.

[v-hashadapu · Accepted solution]

Hi @Anon9876 , Thank you for reaching out to the Microsoft Community Forum.

No, Power BI does not currently allow you to force column headers to wrap independently of column width. Header text will only wrap when it exceeds the width of the column and there is no option to manually insert line breaks or enable force wrap behaviour. If the column is wide enough to display the entire header in one line, Power BI will not wrap it, even if wrapping had occurred previously when the column was narrower. The only way to restore wrapping is to reduce the column width until the text naturally wraps again.

If you're committed to using table visuals and want a vertically stacked layout that looks seamless, your current method of disabling auto-size, applying temporary wide number formatting to align columns and using formatting tricks to hide headers remains the only viable option in Power BI today. This approach, as described by @alish_b , is valid for static reports where layout precision is essential and interactivity or filtering isn't central.

However, if you're open to restructuring your model for a more maintainable and dynamic report, @danextian 's suggestion is the better long-term approach, using a matrix visual with either a disconnected table or calculation groups. This lets you display measures like Current Month and Year-To-Date as row items, eliminates the need for layered visuals or header hacks and aligns better with Power BI's native capabilities for grouping and formatting. It does take some setup, but it’s far more scalable and robust for evolving reporting needs.

[Anon9876]

Hi v-hashadapu, Thank you. I don't know about disconnected tables and calculation groups. I will have to look into those later. I have been given the task of developing our annual budget, so don't have the time to work on the Power BI file this week. FYI, I am not using time intelligence. The source data is all calculated in a SQL query, including the variances. In Power BI I have created measures to sum each of the amounts and added DAX measures to calculate the variance percentages.

@alish_b suggested the formatting of the measures to get consistent columns widths, which does work.  @danextian has suggested calculation groups, which would avoid the need to layer visuals (the video is helpful). I will look into that when I get time. You have answered my questions regarding the column headers and wrapping. I would like to accept all 3 as the solution, but the message you have sent and I am replying to now summarises things well, so I will accept that as that as the solution. Thank you to @alish_b , @danextian  and @v-hashadapu for your help.

[Anon9876]

Hi alish_b. Thanks you for your response. I had turned off the auto-size option so that I could try to manually set the column width to get the word wrapped headers appearing the way I want them, but lining them up is difficult. I will try your suggestion of formatting the measures instead with the auto-size turned on.

I am not sure about the disconnected tables. How does that help? All the amounts shown are measures from a single fact table. There are many others that I still need to add, but to stop the report from being too wide I need to show the current month and year-to-date measures vertically.

[alish_b]

Well with disconnected tables, you could compute a table in the following format at the refresh time (assuming you are using Import mode).

Duration Observed	Actual Revenue	Actual Costs	Actual Margin	Budget Revenue	.......
Current Month	12345	2345	10000	99999	.......
Year To Date	123456	23456	100000	999999	........

After this, it will be basic drag-and-drop. But yes, this can get messy when you have a lot of measures, and then again if there is some filtering requirement such as by Product, you will need to create above rows at that grain too. It would be great if Power BI just offered a fully customizable table at this point but sadly till then we will have to rely on these workarounds or push back on the requirements.

[v-hashadapu]

Hi @Anon9876 , Thank you for reaching out to the Microsoft Community Forum.

Power BI still doesn’t support hiding table headers or locking column widths across visuals. The most reliable workaround is to turn off “Auto-size column width” on both visuals. Temporarily apply wide number formats (like 000000000.00) to stretch columns, align them manually, then revert the formatting.

To hide headers in the second table, set the header font colour to match the background, reduce the font size to 8pt and rename headers to a space (" ") or a zero-width character (U+200B). This makes them visually disappear, though not technically removed. Use the Align tools and Selection Pane to stack the visuals precisely. Enable “Maintain layer order” to prevent interaction issues.

If this helped solve the issue, please consider marking it “Accept as Solution” so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.