Forum Discussion
Apply data to certain rows in a matrix
I'm trying to hide the dates in this matrix at the 2nd row level when expanded but keep the "header" dates.
The dates are the actual completion date and the due date of the overall project, so they do not apply to their "subrows".
How can I approach this?
TIA!
2 Replies
- Daniel29195
Community Champion
Helo Tia CBrinky
in order to control what to show on each level, you can use isinscope function in your measure :
example on how to use it :you have a matrix from 2 levels and
you dont want to show dates in the second level :
measure =
switch(
true() ,
isinscope( tbl_ name[col_name]) , blank(),
isinscope( tblname[col_name_lvl1]) , [calculations you want]
)
hope this makes sense .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅!
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
I don't quite understand the calculations that I'd do in the last part? I only want to hide the dates from the task name rows
