How to Add Total in Power BI



Guide

  1. Open your Power BI desktop and load the report you want to add totals to.

  2. Click on the table visual that needs totals.

  3. In the 'Visualizations' pane on the right, click on the 'Format' icon (paint roller) to access the formatting options.

  4. Scroll down in the formatting menu until you find the 'Totals' section and click to expand it.

  5. Toggle the 'On' switch for 'Totals' to enable sum calculations.

  6. You'll now see totals appear at the bottom of your numeric columns. You can further customize how they display in the formatting options.

🚀

Create your first interactive demo in minutes

No credit card required • Start building today

Start free

    This website uses cookies to enhance the user experience.

    AcceptDecline