Controlling Totals and Subtotals In Power BI

Today, I’ll show how you can control totals and subtotals in your matrix visual in Power BI. This is a problem posted by one of our members at the Enterprise DNA forum wherein the user wants the columns to look like the excel pivot table tabular format with the grand total at the bottom but not the subtotal. I’m going to share a couple of ways on how you can solve this. Brian Links mentioned in the video: Matrix Subtotal Formatting - Enterprise DNA Practice Dataset - Fixing Incorrect Totals - ***** Video Details ***** 00:00 Introduction 00:55 Enterprise DNA practice dataset 01:51 Total sales measure 03:16 Table formatting 04:30 DAX solution 05:18 Total sales SWITCH 06:31 Fixing incorrect totals 08:40 Imposing a slicer ***** Learning Power BI? ***** FREE COURSE - Ultimate Beginners Guide To Power