How to Add Total in Power BI

‍

‍

Here’s how to do it:

‍

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.