Hiding rows in a Matrix

Hi WJ876400 ,

You can try below options.

Option1: Keep Index but make it transparent

Instead of removing the Index column, keep it and make it invisible or appear blank:

1. Go to the Format pane of the Matrix visual.

2. Expand the "Field formatting" section.

3. Choose the Index column.

4. Set the Font color and Background color to match the matrix background (e.g., white or transparent).

5. Optionally, reduce the column width as small as possible.

This way:

• The matrix will not group rows (because Index is still present).

• The column won't disturb readability (effectively hidden).

Option2: Use Table visual instead of Matrix

If you do not need subtotals/grouping logic:

• Consider using a Table visual instead of a Matrix.

• Tables don’t group identical values the same way as matrices.

• You’ll still be able to sort, format, and even hide the index more cleanly.

Option3: Create a Composite Key Column

Instead of showing the Index, create a new column like

UniqueAssessmentKey = Unit & " | " & 'Assessment and Hand In Date' & " | " & Index

Use that in the Matrix Rows, and then apply the same formatting trick (hide font color) or truncate using a measure to only show meaningful parts.

Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.