Forum Discussion
Show all levels in matrix
How can I get this Matrix to show Type/State/Title for all the levels?
2 Replies
- amitchandak
Super User
greekjgg , are you using some row context in measures ?
if they are not measures you can put them on a row and use stepped layout off and use per row level to disable few sub total totals
Can you share a sample pbix after removing sensitive data.Correct!
I could not use the Path Function because not every parentid is in the workitem id column so it throws an error. I used "lookupvalue" to create 6 columns in order to replicate the entire hierarchy.
Level 4 = LOOKUPVALUE('TFS ID Hierarchy' [Level 5], 'TFS ID Hierarchy' [WorkItemId], 'TFS ID Hierarchy'[Level 5], " ")If I start putting more than just the ID's in the row column it starts getting messy. I tried the "concatenate" but its expensive with memory and slows the model down. My current idea was to try a index key based on the ranking, if Level 1 then 1, if level 2, then 2, etc....., but I'm not sure that would expose the data I want in the empty columns.
