Matrix Column Grand Total

hi, Sharksguts

After my research, I'm afraid it couldn't achieve in Power BI for now.

But you may try this way, add a matrix or table visual with only column Part Number and Value, then they will be the Grand Total for

basic matrix column, and they can interact with each other.

For your requirement, you could post your new idea in Power BI ideas and make this feature coming sooner.

another question, for you want to show the values of every day for the column, this exceeds the maximum number of items that can be displayed for column, Not only does it not have grand total but also the sub total.

So you could these two ways:

1. move the column Values field into row and row Value field into column.

2. use a slicer to filter data to reduce the number of items of date.

Best Regards,

Lin