Matrix Column Hide Values when collapsed

Question

Hi,I have a matrix visual here. Is there a way to make the "Last Update" column hide the values until the "Sharepoint Status" is expanded?So when it is viewed like this, the dates should not appear. It will only appear when the "Sharepoint Status" is expanded.Your response is much appreciated!

jgeddes · Answer

You could likely use ISINSCOPE in the 'Last Update' measure.Something along the lines of&nbsp;IF(ISINSCOPE(SharePoint Status),"",[Last Update])Microsoft Learn - DAX - ISINSCOPE&nbsp;&nbsp;&nbsp;

jgeddes · Answer

Can you share the code for [Last Update (M)] measure?

rlsid17 · Answer

I tried this and the [Last Update] column is encountering an error.

jgeddes · Answer

What error did you receive?

rlsid17 · Answer

This is the error:It says the column does not exist but it already exists from the data source.

Forum Discussion

Matrix Column Hide Values when collapsed

6 Replies

Related content

Collapse and expand columns on matrix

expand collapse for column matrix

Matrix: No option to expand collapse columns with +/- ??

Expand/Collapse Matrix Columns

Matrix Column Widths