Show subtotal for specific column only

[Anonymous]

I have a matrix table and I want to only show subtotals for the currency columns, not text columns. However it seems I can only turn it on/off for all columns. Is this possible?

[skchung]

Please try the "Per row level" in "Subtotals" section

https://www.ehansalytics.com/blog/2019/4/21/the-matrix-visual-and-ways-to-show-subtotals

[Anonymous]

Within Field Formatting, you can choose the columns in which you don't want subtotals/totals to show up and format the field to have the text and background matching colors and apply only to the subtotal/totals as appropriate. The data will still be there but it will appear invisible

[v-lili6-msft]

hi, @Anonymous

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

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

Best Regards,

Lin