Lock column headers in a matrix visual

[tannerwhitesell]

Is there a way for me to lock the columns on a matrix so they don't filter out when a user selects a model in the slicer on the report? I would like to keep the other columns because we have images of the product over the columns. For example, if you select Model B in the slicer it puts Model B's data under the Model A picture. Any help would be greatly appreciated. 

Current Outcome if you select a model in the slicer

[az38 · Accepted solution]

Hi @tannerwhitesell 

I can only imagine your data model, but in the common case you can do the next:

a) create an once-column "Models" Table

b) in your "Data" table create a "Model" column (I assume it already exists).

c) create relationships Models-Data

d) use 'Models'[Model] column as Columns for matrix

e) use 'Data'[Model] column as a slicer

f) create a measure

_mValue = CALCULATE ( SUM (Data[Value]) ) + 0

g) use new measure as a value for matrix

h) enjoy:

[tannerwhitesell]

Thank you for the help. That worked