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

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.