Forum Discussion
Lock column headers in a matrix visual
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
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]) ) + 0g) use new measure as a value for matrix
h) enjoy:
2 Replies
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]) ) + 0g) use new measure as a value for matrix
h) enjoy:
Thank you for the help. That worked
