Hiding rows in a Matrix

[WJ876400]

Hi,

I have a matrix where the rows are being grouped as they have the same data but I want to stop it grouping. I have added the index column which has worked but I want to hide the index column is this possible.

Without the index column it looks like this -

but there are two coursework worth 50% with the same hand in date and different marks so it needs to look like this

but not have the index column. I have just rezised the column by dragging it but it then makes all the rows to big and unreadable on the matrix.

is there a way to hide the index without getting this result.

any help is appreciated.

thanks

[ajaybabuinturi · Accepted solution]

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.

[speedramps]

On a Table visual, you can right click on the value column and select "Do not summarize".

There is no equivalent functionality on Matrix visual.

I therefore suggest that you create a measures and use a Table visual to acheive you desired output.

I want to help you more but your description is too vague. Please write it again.

You will get a quicker and better response without misunderstandings if you put time and effort into carefully writing a clear problem description with example input and output data. Look forward to helping you when this information is forthcoming

* Please give a simple non-technical functional description of what you want
* Keep it simple and break large projects into smaller questions and ask just one question per ticket.
* Rename columns to user friendly names. Avoid your own system jargon that we may not understand.
* Most importantly please provide example input data as table text (not a screen print) so helpers can import the data to build a solution for you. (Learn how to share data below)
* Provide the example desired output, with a clear step-by-step description of calculations and the process flow.
* Take time and care to use the same table and field names in the input, output and description so we can understand your problem and help you.
* Remove any unneeded tables, rows or columns which may cause confusion. Keep it short and concise with the minimal information regarding the key problem.
* Remember not to share private data ... we don't want you to get into trouble. ‌‌
* Please click the thumbs up button for these helpful hints and tips. Thank you.

Learn how to attach data in the forum using OneDrive:-
* Save your file in a OneDrive folder
* Right click on the file and click the “Share” blue cloud icon
* Click the bottom “Copy” button
* Click” Anyone with link can edit”
* Click “Can Edit”
* Click “Can View”
* Click “Apply” button
* Click “Copy”
* Paste the generated link via the forum, email, chat, or any other method.
* Helpers can then download your data, build a solution and share it back.

Learn how to attach data in the forum using Dropbox:-
1. Open Dropbox: Access the Dropbox folder on your computer or through the Dropbox web interface.
2. Select File/Folder: Find the file or folder you want to share.
3. Click Share (or Get Link): Look for a "Share" option or a similar "Get Link" option.
4. Choose Permissions: Decide whether to allow "view only" or "view and download" access.
5. Copy and Share: Copy the generated link and share it with anyone via the forum, email, chat, or any other method.