In this video, I’ll show how you can use Calculation Groups to create custom groupings and insightful visualization particularly if you are unable to add new tables and columns in your Power BI desktop.

Mudassir

Links mentioned in the video:
Measure on X-Axis of Visual - forum.enterprisedna.co/t/measure-on-x-axis-of-visual-using-switch-to-segment-a-continuous-variable/11821
Introduction to Calculation Groups - youtube.com/watch?v=XCugcQ-_Zfk

***** Video Details *****
00:00 Introduction
00:31 The goal
01:08 How to create custom grouping
02:03 The problem
02:55 How to create a Selective Measure
05:30 How to apply on Axis
05:45 How to change the order of Categories

***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE - Power BI Resources - enterprisedna.co/power-bi-resources
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership - enterprisedna.co/membership
Enterprise DNA Online - portal.enterprisedna.co/
Enterprise DNA Events - enterprisedna.co/enterprise-dna-events-page/

• Calculation Groups To Your Rescue - DAX Tutorial ( Download)
• Using calculation groups to selectively replace measures in DAX expressions ( Download)
• Calculation Groups & DAX Slicer ( Download)
• Using Calculation Groups to give end users much more insight with much less DAX ( Download)
• How to effectively use Power BI calculating groups when you have a lot ( Download)
• DAX: Better measures with Calculation Groups ( Download)
• Introduction To Calculation Groups In Power BI ( Download)
• Fix my Calculation Group in Power BI ( Download)
• How Small Multiple Visual Interacts With Calculation Groups In Power BI ( Download)
• Nashville Power BI User Group (Dec 2020) | Using Calculation Groups in Dax ( Download)
• Calculation Groups (with Kane Snyder) ( Download)
• Dynamic Power BI Report with Calculation Groups - Intro To Problem Of The Week #7 ( Download)
• Microsoft Power BI UK User Group Using calculation groups in DAX with Alberto Ferrari ( Download)
• Are you still not using Calculation Groups! ( Download)
• Power BI Calculation Groups ( Download)