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 – https://forum.enterprisedna.co/t/matrix-subtotal-formatting/17080
Enterprise DNA Practice Dataset – https://blog.enterprisedna.co/power-bi-external-tools-installing-practice-dataset/
Fixing Incorrect Totals – https://forum.enterprisedna.co/t/fix-incorrect-totals/8834

***** 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 BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #PowerQuery #PowerQueryTutorial

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.