Show Value in Matrix instead of aggregate (sum/count/first/last)

[Nickniday]

Hello all,

I've done a good chunk of reading through posts and tried to get as far as I can but maybe the functionality I'm looking for just doesn't exist. I based most of my work off of https://www.daxpatterns.com/parent-child-hierarchies/# so far I have the following: 

Which is more or less what I want, we have initiatives with Epics underneath in ADO (I'm using analytics views in ADO to pull the data in and have the hierarchies all mapped up) 

The jist of my question is I want the +/- functionality to drill down, however I don't want the First State/Last State/Count etc, I just want the state of the item. In this example "Search" has it's own independant state and the sub item "Mobile Phase 1 etc" has a state as well, neither of these are active as it's just going down the hierarchy and pulling the first state.

Is there any way in a matrix to show just the value of the data point for that line item? Otherwise I assume I have to use a table where I lose out on the +/- functionality.

Any help would be appreciated! I didn't add data as I assume this is a high level question, but I can provide more info if needed.

[v-luwang-msft]

Hi @Nickniday ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[Nickniday]

Unfortunately not solved yet, I'm trying to see if there is anything I can do but nothing is panning out just yet...

[jdbuchanan71]

@Nickniday 

Move state from values to rows should give you what you want.

[Nickniday]

That gives me state underneath items which isn't what I'm looking for. I'd like the state to be in line with the item as well as at the top level. AKA PO Redesign has it's own state that I want to show.