Get your totals to Matrix Header

  • Published
  • Posted in General / Power BI
  • Updated
  • 1 min read

Hi everyone! As you know tables and matrix visuals are the most go to visual for any Power BI Report.
And there may be a chance where you may have a requirement to display the totals right to the header
side of the matrix visual. Let’s do this right away in a few simple steps.
Scenario: Below is the matrix visual with Totals at the bottom.

Objective: To have the totals in the head row.

Step1. Go to Data View and Add a calculated column as below:

You shall see the column Total with values having Total as a text value.

Step 2: Navigate this Total in your Matrix to the top row.

Step 3. Lastly, go to the Visualization pane again and inside the format pane go to Row Subtotals, turn on the Per Row Level and turn off the Totals.

And we have our desired result.

Thank you!

Vinit Pawar
Data Analyst

 

Addend Analytics is a Microsoft Gold Partner based in Mumbai, India, and a branch office in the U.S.

Addend has successfully implemented 100+ Microsoft Power BI and Business Central projects for 100+ clients across sectors like Financial Services, Banking, Insurance, Retail, Sales, Manufacturing, Real estate, Logistics, and Healthcare in countries like the US, Europe, Switzerland, and Australia.

Get a free consultation now by emailing us or contacting us.

Email Us Or Contact Us