Skip to main content
Microsoft Idea

Power BI

Needs Votes

Multi-line column headers for tables with word wrap

Vote (59) Share
Jamie Llewellyn's profile image

Jamie Llewellyn on 07 Apr 2016 02:19:42

There are a lot of excel formatting features that would be nice in Power BI but at the top of my list is word wrapping for long column heading names. For example, Proposed Fund Purchase Price would wrap to
|Proposed Fund |
|Purchase Price |
| $120,000|
because the data in that column would fit nicely under that text and I could fit more columns on my table.

Comments (6)
Jamie Llewellyn's profile image Profile Picture

Barry Bilewitz on 05 Jul 2020 23:39:41

RE: Multi-line column headers for tables with word wrap

Just checked - there is a word-wrap feature for column headings (Nov 2018 PBI Desktop).

Jamie Llewellyn's profile image Profile Picture

Leonardo Elmor on 05 Jul 2020 23:13:35

RE: Multi-line column headers for tables with word wrap

This is a critical and simple feature to allow the headers to be wrapped based on the table width defined by the user.

Jamie Llewellyn's profile image Profile Picture

Aleksandr Lazutkin on 05 Jul 2020 22:37:10

RE: Multi-line column headers for tables with word wrap

It is not always necessary to use abbreviations in the column. Therefore we need an analogue "wrap text" in Excel (and change row height)

Jamie Llewellyn's profile image Profile Picture

Christopher Post on 05 Jul 2020 22:26:10

RE: Multi-line column headers for tables with word wrap

I think that this is a duplicate request. - See https://ideas.powerbi.com/forums/265200-power-bi/suggestions/6700612-text-wrap-in-tables-cards-etc-in-dashboards

Jamie Llewellyn's profile image Profile Picture

Mike Honey on 05 Jul 2020 22:21:20

RE: Multi-line column headers for tables with word wrap

Actually AFAIK Excel doesn't do this - it would automatically widen such a table column to the full width of the column heading. In Excel you can manually set the width and manually set the column headings to wrap. This may be "too hard" and not worth working on - I imagine it would take a lot of coding to judge when to wrap and how wide to make the column. Perhaps manual column width and wrapping controls are a more realistic ask?

Jamie Llewellyn's profile image Profile Picture

Mike Honey on 05 Jul 2020 22:21:20

RE: Multi-line column headers for tables with word wrap

I'm not sure why this has been categorized under Custom Visuals - I think it refers to the built-in table object?