Power Bi Visual Calculations

Create powerful Power BI visuals, easily and efficiently, without creating measures or using CALCULATE!

What you'll learn

Why DAX is hard and why it's not visual

The Power BI Visual Calculations environment

Running totals

Moving averages

Percent of parent / Percent of grand total / Percent of children

Mastering the Axis and Reset parameters (for hierarchies)

Previous / Next / First / Last

Requirements

Development experience with Power BI and DAX would be helpful

Description

Welcome to the exciting and revolutionary world of Power BI Visual Calculations! In this course, we’ll dive deep into a groundbreaking feature that transforms the way you write DAX (Data Analysis Expressions). Whether you’re a seasoned data professional or just starting your analytics journey, visual calculations will revolutionize your approach to creating insightful reports and dashboards while creating fewer DAX measures.So, what exactly are visual calculations?Visual calculations allow you to define and execute DAX calculations directly on a visual element within your Power BI report. Imagine having the power to create custom calculations right where you need them—on a chart, table, or any other visual component. No more complex semantic models, no more convoluted DAX expressions and no more CALCULATE! With visual calculations, you can effortlessly refer to data within the visual itself, including columns, measures, or even other visual calculations.Here’s what you’ll learn in this course:DAX is hard. We’ll discuss why DAX is hard and why it’s not visual.Design Goals: What did the Power BI team have in mind when designing visual calculations?Creating Visual Calculations: Learn how to add visual calculations to your visuals, whether it’s calculating profit margins, running totals, or moving averages.Visual Calculations Template Functions: Template functions and their associated array of parameters make visual calculations the powerhouse it is. You will learn all about them in this course.New DAX Functions: With the release of visual calculations the Power BI team has released many new functions. You’ll learn about them in this course.Quiz and exercises.By the end of this course, you’ll be equipped with the skills to enhance your Power BI reports, simplify your DAX code, and unlock new possibilities for data-driven insights.

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: DAX is Hard!

Lecture 2 Part 1

Lecture 3 Part 2

Lecture 4 Part 3

Lecture 5 Why DAX is not Visual

Section 3: Visual Calculations

Lecture 6 Design Goals and Overview

Lecture 7 Getting Started Part 1

Lecture 8 Getting Started Part 2

Lecture 9 Getting Started Part 3

Lecture 10 Demo Part 1

Lecture 11 Demo Part 2

Lecture 12 Demo Part 3

Lecture 13 Demo Part 4

Lecture 14 Demo Part 5

Lecture 15 Demo Part 6

Lecture 16 Demo Part 7

Lecture 17 Demo Part 8

Lecture 18 Demo Part 9

Lecture 19 New Functions

Section 4: Test Your Knowledge / Exercises

Lecture 20 Quiz

Lecture 21 Exercise 1

Lecture 22 Exercise 2

Lecture 23 Exercise 3

All Power BI developers