Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Stop Matrix Autosizing

    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 lo...
Need Help
  • tex628's avatar
    tex628
    6 years ago

    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. 

IronBI's avatar
IronBI
Frequent Visitor
1 year ago

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.