Displaying values and conditional formatting for main item in matrix when rows are collapsed

[Anonymous]

Hello,

I have a matrix that looks like the following:

When I collapse the rows it looks like this:

Currently, Power BI displays the % complete columns as sums of the values underneath, but I want it to display what's actually in that column for 'Test Item 2' in the Excel sheet I'm pulling data from.

Also, is there a way to setup the conditional formatting so the icon is displayed for the main item when it's collapsed? I want it to also display the icon by conditional formatting based on the value for 'Test Item 2' (which isn't 1.43 btw, that's a sum). And is it possible to show the data bar for the % complete on the main row when it's collapsed?

Any help is appreciated. Thanks!

[Greg_Deckler]

Maybe, a measure totals problem? Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

[Anonymous]

Hi @Greg_Deckler, 

I don't think I necessarily need a calculated measure to deal with the 'Total' row values (or maybe I'm misinterpreting your solution). 

Here's what the test Excel sheet looks like:

When collapsed, I wanted the 'Test Item 2' to display what's already in the Excel sheet, so 20% under the '% Complete (excel)' column, and display a red icon under the 'Status' column (may need conditional formatting in PBI). Do you think this is possible?

[Greg_Deckler]

@Anonymous , as @v-shex-msft has confirmed, you actually do need a measure. 🙂

[v-shex-msft]

HI @Anonymous,

Currently, you can't directly modify original table fields by condition formations feature. (it is used to formating with conditions and it not able to replace record values and change its summary mode)

You can refer to Greg_Deckler's 'measure total' blog to use measure formula with if statement to check the row contents level.
Then you can switch between different expression based on row contents level and return correspond records to replace original value fields to use on matrix.

Regards,

Xiaoxin Sheng

[Anonymous]

Once again my picture doesn't display in the actual post. Here's what the matrix looks like when expanded. 

Thanks.