Forum Discussion
Column width in matrix
Can you just turn off auto-sizing and manually set the width?
Thanks a lot, smoupre!
Switching the auto-size option to off worked. I cannot see where one can define the width of the measure columns but for the moment it doesn't matter as the visual calculates the width correctly (in my case auto-sizing works correctly with auto-size = off :-))
I feel a bit silly as I am almost sure I have tried this before and it didn't work.
Thanks once again!
Tsanka, you and I are experiencing the same two issues, which puts us in a catch-22 situation.
If you want column totals (and I've even had the problem in columns that were not totals as, just big values) to be displayed in full (not have 3 elipses...), then you need to turn off auto-sizing and adjust the widths accordingly. But if auto-sizing is off, then the matrix often doesn't respond to filtering by a slicer. Ouch! (For now, we're opting to suffer with the clipped text, as the lesser of two evils.)
Post for the other issue, for other readers:
Addendum: My font size when experiencing the problem is 10 pt or higher. When I set it to 9 pt, the auto-sizing is ok (but now my font size is smaller than I'd like.)
JenM, you are so right - it is a catch-22 situation. At least now thanks to Tishchenko we have a work around for the first issue.
Let's be optmistic that the powerBI team will solve the issues soon (or at least one of them). Cheers :smileyhappy:
According to me the new (Feb) version of PowerBI desktop solves that bug - both in the desktop and in the published report.
Thanks, that 9pt is the catch. I made the text size 9 ,auto size =off and image =32 and it worked :)
