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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.