Matrix Column Hide Values when collapsed

[RLSid17]

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]

What error did you receive?

[RLSid17]

This is the error:

It says the column does not exist but it already exists from the data source.

[jgeddes]

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

[RLSid17]

Oh was it supposed to be a measure? What would be the measure for it?

[jgeddes]

You could likely use ISINSCOPE in the 'Last Update' measure.
Something along the lines of 

IF(
ISINSCOPE(SharePoint Status),
"",
[Last Update]
)

Microsoft Learn - DAX - ISINSCOPE 

[RLSid17]

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