Forum Discussion
RLSid17
3 years agoHelper III
Matrix Column Hide Values when collapsed
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!
6 Replies
- jgeddesSuper User
You could likely use ISINSCOPE in the 'Last Update' measure.
Something along the lines ofIF(
ISINSCOPE(SharePoint Status),
"",
[Last Update]
)Microsoft Learn - DAX - ISINSCOPE
- RLSid17Helper III
I tried this and the [Last Update] column is encountering an error.
- jgeddesSuper User
What error did you receive?