Stop Matrix Autosizing

[Anonymous]

Guys, is there a way to stop the Matrix resixing when you select a slicer.  The first photo (photo1) shows no filters selected which fills the whole bottom section.  This is how i want it to look.  Howvever, as soon as you select a name in the slicer it reverts to photo 2.  This look really untidy.  Is there no way to lock the matrix to the center?  Thanks

Photo 1 = no slicers

Photo 2 = sliver engaged

[IronBI]

Hi, I usually never post, just a lurker. However, I'd like to share how I solved it, based on inputs and suggestions around the web.

Basically, my year, wuarter or month columns were resizing once I applied a different slicer. Even though auto-rezise was disabled.

The answer: I added several dummy columns in my calendar table, with constant values and applied them to the header of the matrix. Tinkled with the font and size to get it as good as it could get. Now, if I change the slicer setting my columns are staying constant. Now, I'll just hide the constant width value.

[tex628 · Accepted solution]

It's resizing since some of the column values no longer appears in the selection. To my knowledge there is no way to make the matrix dynamically adapt in size. 

What you could do is replace the column dimension with ALOT of measures. 

1-1 =
Calculate(
[Expression], 
DimensionValue = "1-1"
)

1Link = 
Calculate(
[Expression], 
DimensionValue = "1Link" 
)

etc. 

This will make it so that all the columns will stay no matter the selection and the matrix should always remain the same size. It's tedious and a quite bad solution but it will solve your issue. 

[Anonymous]

Thanks for the reply i appreciate it.  I will give that a go.