cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
olopuc Frequent Visitor
Frequent Visitor

Is There any way to fix Column Widths in a Matrix

In a Matrix visualization, is there any way to fix the column widths so they don't change. Specifically, I have a matrix that has two Values per Column Item: 

 

Project 
CostUnit Rate 

 

I always want the Cost column to be one uniform size and the Unit Rate to be a different uniform size for each Project which then fixes the uniform width of the Project field. Power BI Desktop seems to retain the width values for each Project-Cost and Project-UnitRate Column independantly as I can have different widths for Project A vs Project B. That is correct, but as I ad new projects via data updats, then I (or the end user) needs to adjust each one as they come along. Shouldn't I be able to preset these values, presumably under the column formatting section?

 

Is there an easy way to do this (if so please let me know) or is this an enhancement that needs to be added at some point?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
v-jiascu-msft Super Contributor
Super Contributor

Re: Is There any way to fix Column Widths in a Matrix

Hi @olopuc,

 

According to my test,

1. When the "auto-size" of "column headers" is off, the column will keep its length, which won't change automatically.

2. When the new data is added the first time, the column would fit its width automatically. 

3. First set "word wrap" on, then set "auto-size" off, it would satisfy your scenario.

 

Please have a try. 

 Is There any way to fix Column Widths in a Matrix2.jpg

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
13 REPLIES 13
v-jiascu-msft Super Contributor
Super Contributor

Re: Is There any way to fix Column Widths in a Matrix

Hi @olopuc,

 

Please set "Auto-size column size" to "off". It will work according to my test. Maybe you need to upgrade Power BI Desktop to the latest version (2.48.4792.721 64-bit (July 2017)).Is There any way to fix Column Widths in a Matrix.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
olopuc Frequent Visitor
Frequent Visitor

Re: Is There any way to fix Column Widths in a Matrix

This goes beyond the Auto-Size option.

 

Once Auto-Size is turned off, I am trying to understand how Power BI then determines the column size for new columns that are added to the matrix. So I might have 3 projects to start out with six total columns. I can set the size for each of those with the Auto-Size turned off. But the next time I refresh, two new projects are added which creates 4 new columns and I'm trying to figure out how these are sized. I don't want to have to force the end user to adjust column widths every time new information is added to the report.  In the data set I am using the Project field has a number and description component so it might look like this:

 

|12345 - Intercontinental Roadways Terminal #6|

|Cost          |   Unit Rate                                        |

 

and I want the columns to be collapsed so the Project always word wraps based on fixed widths for the Cost and Unit Rate columns:

 

| 12345 - Intercontinental | 45678 - Project B789       |

|  Roadways Terminal #6   |                                         |

| Cost             | Unit Rate   | Cost             | Unit Rate   |

 

I am pretty sure the functionality does not exist at this time, but I'm trying to confirm that because it is needed for the report I am designing. I wanted to see if there was any work around that might be available.

 

Highlighted
v-jiascu-msft Super Contributor
Super Contributor

Re: Is There any way to fix Column Widths in a Matrix

Hi @olopuc,

 

According to my test,

1. When the "auto-size" of "column headers" is off, the column will keep its length, which won't change automatically.

2. When the new data is added the first time, the column would fit its width automatically. 

3. First set "word wrap" on, then set "auto-size" off, it would satisfy your scenario.

 

Please have a try. 

 Is There any way to fix Column Widths in a Matrix2.jpg

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
olopuc Frequent Visitor
Frequent Visitor

Re: Is There any way to fix Column Widths in a Matrix

I can get this to work, but only if there is only one initial project in the list. Or else I think I have to set all of the projects to the same column widths (by eyesite it seems) and then the new ones will fall in line.

 

That does not seem very pratical. 

 

Also, it seems like the order in the selections of Word wrap and Autofit is crucial (though I did not rigourously try to confimr that).

 

Either way thanks for your help. At least I understand what seems to be involved and will consider suggesting a better work around.

MDelmorio Frequent Visitor
Frequent Visitor

Re: Is There any way to fix Column Widths in a Matrix

It not works in may case. I have a table that should show 3 months in columns, in another chart in same page there os another chart connected to a slicer where I can select details of an specific month. When I change the month throught the slice columns in the table change their width.

MDelmorio Frequent Visitor
Frequent Visitor

Re: Is There any way to fix Column Widths in a Matrix

Dale,

 

it´s not working in my case. I have a chart interconected with  slicer and a table stand alone. Anytime a change a month in the slicer my table is afected changing columns witdth. 

odoro Frequent Visitor
Frequent Visitor

Re: Is There any way to fix Column Widths in a Matrix

has anyone found a fix for this?  I have created a matrix that returns data for a rolling 12 week period.  The column header is the financial week number and the date of the last date of the financial week. 

 

Once I have published the report and the weeks roll over the column width loses the word wrap and takes on the full length of the text of the week header.

 

It is a fixed 12 column matrix and I need it to remain so but the header of the columns will change as the weeks roll over.   I need it to maintain the word wrap and fix the width.

odoro Frequent Visitor
Frequent Visitor

Re: Is There any way to fix Column Widths in a Matrix

Word Wrap is ON and auto-size is OFF

Carina1178 Frequent Visitor
Frequent Visitor

Re: Is There any way to fix Column Widths in a Matrix

Is there a way also to fix the "Row Headers" in a matrix?
Even if I fix the "Column Headers" the table still "jumps around" when drilling down in the rows.
TIA

 

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 302 members 3,299 guests
Please welcome our newest community members: