Today, I\u2019ll 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.<\/p>\n

Brian<\/p>\n

Links mentioned in the video:
\nMatrix Subtotal Formatting – https:\/\/forum.enterprisedna.co\/t\/matrix-subtotal-formatting\/17080<\/a>
\nEnterprise DNA Practice Dataset – https:\/\/blog.enterprisedna.co\/power-bi-external-tools-installing-practice-dataset\/<\/a>
\nFixing Incorrect Totals – https:\/\/forum.enterprisedna.co\/t\/fix-incorrect-totals\/8834<\/a> <\/p>\n

***** Video Details *****
\n00:00 Introduction
\n00:55 Enterprise DNA practice dataset
\n01:51 Total sales measure
\n03:16 Table formatting
\n04:30 DAX solution
\n05:18 Total sales SWITCH
\n06:31 Fixing incorrect totals
\n08:40 Imposing a slicer<\/p>\n

***** Learning Power BI? *****
\nFREE COURSE – Ultimate Beginners Guide To Power BI – http:\/\/portal.enterprisedna.co\/p\/ultimate-beginners-guide-to-power-bi<\/a>
\nFREE COURSE – Ultimate Beginners Guide To DAX – http:\/\/portal.enterprisedna.co\/p\/ultimate-beginners-guide-to-dax<\/a>
\nFREE – Power BI Resources – http:\/\/enterprisedna.co\/power-bi-resources<\/a>
\nFREE – 60 Page DAX Reference Guide Download – https:\/\/enterprisedna.co\/dax-formula-reference-guide-download\/<\/a>
\nEnterprise DNA Membership – https:\/\/enterprisedna.co\/membership<\/a>
\nEnterprise DNA Online – http:\/\/portal.enterprisedna.co\/<\/a>
\nEnterprise DNA Events – https:\/\/enterprisedna.co\/enterprise-dna-events-page\/<\/a><\/p>\n

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #PowerQuery #PowerQueryTutorial<\/p>\n","protected":false},"excerpt":{"rendered":"

Today, I\u2019ll 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<\/p>\n","protected":false},"author":1,"featured_media":2544,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":""},"categories":[21,137],"tags":[214,146,143,215,216],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2021\/08\/1e44Km4KaJg.jpg?fit=1280%2C720&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7QB1z-ER","_links":{"self":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/2533"}],"collection":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/comments?post=2533"}],"version-history":[{"count":1,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/2533\/revisions"}],"predecessor-version":[{"id":2633,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/2533\/revisions\/2633"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media\/2544"}],"wp:attachment":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media?parent=2533"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/categories?post=2533"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/tags?post=2533"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}