Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
dthompsonKairos
Helper II
Helper II

Getting a value from a Matrix

I think I know the answer (Nope, you can't), but I am compelled to ask anyway.

 

Is there a way to extract a value from a matrix given a column name and row name?

dthompsonKairos_0-1739282272470.png

 

For the purpose of calculations on the subtotals. I figure that I would need to change the Subtotal titles to have unique names.

This matrix does not represent a single table.

Thx

2 REPLIES 2
Anonymous
Not applicable

Hi @dthompsonKairos ,

Sorry, your request cannot be met at present. This is a field generated by the matrix visual object itself. You can only modify all subtotals to a certain name at the same time, but you cannot modify a subtotal to a unique name.

I suggest you post your ideas here or search to see if there are others with the same ideas as yours and give them a thumbs up. Maybe your ideas will be adopted and realized one day in the future:
https://ideas.fabric.microsoft.com/ 

Best Regards,
Dino Tao

Ya, I figured. Too bad. I'll make the suggestion.

Thx

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.