In this tutorial, Greg tackles a couple of his favorite topics in Power BI — Measure Totals and Matrix Table Visualizations. Greg will particularly demonstrate how you can fix incorrect measure totals using Deneb.

***** Video Details *****
00:00 Introduction
01:58 Overview of custom visual
02:35 Measure Total issue
04:04 Deneb visual
13:06 Matrix visual

***** Related Links *****
Creating a Deneb Matrix by Power BI Guy – https://youtu.be/kXS8haj1PDs

***** 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 Continue reading “How To Fix Measure Totals With Deneb” →

Great way to showcase the analytical power of using DAX in Power BI. Learn how to show if sales margins (or any types of margins) are changing through time. Look to find trends in the data using Power BI.

***** Video Details *****
00:00 Introduction
00:55 Profit margins
02:23 Profit growth
04:29 Identifying trends
07:00 Individual transactions

***** 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://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download Continue reading “Answer If Margins Are Expanding or Contracting Through Time With Power BI [2022 Update]” →

Scenario analysis is all about predicting what outcome could occur in the future. Sam is a huge promoter of this type of analysis in Power BI, he thinks it makes a big difference and adds real value to organisations. In this video, Sam showcases many steps around layering scenario variables into your analysis.

***** Video Details *****
00:00 Introduction
01:54 Layering scenarios
02:09 Total sales
03:04 Scenario profits
05:18 Cumulative scenarios
07:11 Conclusion

***** 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 Continue reading “Extending Layered Scenario Analysis Techniques – Advanced DAX and Power BI [2022 Update]” →

Brian previously talked about the best way to implement conditional formatting, which is by using the field value option because you can use the transparency masks on hex codes. In this video, Brian shows how you can utilize this transparency mask.

***** Video Details *****
00:00 Introduction
00:39 The goal
01:51 Numeric parameter slider
02:01 Color
02:20 CF Bar measure
03:40 Dynamic font measure

***** 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://www.enterprisedna.co/power-bi-resources
FREE – Continue reading “Transparency Magic In Power BI With DAX” →

Expand your thinking around what’s possible with Power BI! What you can achieve from an analytical perspective with DAX is incredible. In this video, Sam demonstrates how you can layer multiple scenarios into your analysis through supporting tables and slicers applied in a Sales & Profit data.

***** Video Details *****
00:00 Introduction
02:07 Supporting tables
05:40 Using SUMX in scenario profits measure
07:39 Checking the formula

***** 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 – Continue reading “Multi-layered Scenario Analysis Using DAX In Power BI [2022 Update]” →