How do I create a report with subtotals and a grand total in Power BI?

report business-intelligence subtotal powerbi
dotnetN00b picture dotnetN00b · Jul 10, 2015 · Viewed 7.9k times · Source

Currently, I'm using the Power BI Designer (newest version). I'm completely new to it. I'm wondering how to get the subtotal of a group of items and then get the report grand total. I only need the subtotal for one column (ie. price). The grouping will be on 3 columns (date, location, itemname).

Power BI is connected to a Azure SQL database (not SSAS).

Answer

Lukasz P. picture Lukasz P. · Jul 15, 2015

Update: Matrix is now supported in both Power BI Desktop and PowerBI.com.

Just add the 3 levels of grouping and the measure you want. The subtotals will show no problem.

Related questions

How to create BIRT report based on multiple data sets

I need help in creating a BIRT report; the situation is that I have multiple queries but the report all columns should be grouped by One column for example (Operator) Like : Operator | Expr1 | Expr2 | Expr3 | Expr4 | op1 | ## | ## | ## | ## | op2 | ## | ## | ## | ## | op3 | ## | ## | ## | ## | How …

Read More
How can I generate an HTML report for Junit results?

Is there a way to (easily) generate a HTML report that contains the tests results ? I am currently using JUnit in addition to Selenium for testing web apps UI. PS: Given the project structure I am not supposed to use …

Read More
How to analyze a JMeter summary report?

I get the following result when I run a load test. Can any one help me to read the report? the number of thread = '500 ' ramp up period = '1' Sample = '500' Avg = '20917' min = '820' …

Read More