Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Show subtotal for specific column only

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?

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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