topic Re: Power Matrix visual in Developer

Power Matrix visual

KPalmer2022 — Thu, 21 May 2026 18:59:33 GMT

I have a table with a [Feet] = vlookupvalue (numerical value) from a reference table for a value by individual record. I need to have a matrix that will summarize the value [Feet] for a top level group and then multiple sub-level groups and yet show the drilld own of the individual records/rows [FEET] of each record such that for example:


	FEET	ROW TOTALS
PART XYZ	60	60
SHIFT A	60	60
Line-3	30	30
Record 1	10
Record 2	10
Record 3	10
Line-4	30	30
Record 1	10
Record 2	10
Record 3	10

When I use a Matrix visual, I get close, but each individual record sahows as a total and not the individual record values?

Re: Power Matrix visual

v-saisrao-msft — Fri, 22 May 2026 09:50:15 GMT

Hi @KPalmer2022,

I have reproduced the issue using sample data in Power BI Desktop and was able to achieve the expected output where parent levels show aggregated totals while individual record rows display their actual Feet values. I have attached the PBIX file below for your reference.

Thank you.

Re: Power Matrix visual

v-saisrao-msft — Mon, 25 May 2026 04:45:02 GMT

Hi @KPalmer2022,

Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.

Thank you.

Re: Power Matrix visual

v-saisrao-msft — Thu, 28 May 2026 11:47:29 GMT

Hi @KPalmer2022,

Checking in to see if your issue has been resolved. let us know if you still need any assistance.

Thank you.