Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 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 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

 

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

3 Replies

  • tex628's avatar
    tex628
    Community Champion
    7 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. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

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

  • 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.