Video Library
Multi-Language Support Capabilities in Power BI
JEREMY BLACK & KIRILL PERIAN (Data Driven Solutions) Creating a multi-language reporting solution in Power BI presents a number of challenges along the way. Our team would like to share our experience with these challenges and some ways to overcome them, while highlighting...
23 January, 2019
Order of Evaluation in DAX & Variables
RACHEL DYER (CSG Pro) Rachel Dyer is the Vice President of Analytics at CSG Pro with in-depth expertise of the Microsoft BI stack and dimensional modeling. She has a broad management background and strong communications skills, coupled with considerable technical experience in platform...
23 January, 2019
Introduction to M Programming for the Power BI Warrior
TED PATTISON (Critical Path Training) In this user group talk, Ted Pattison will deliver a fast-paced primer on the fundamentals of the M programming language. This session aims to provide a solid foundation for writing M code in the Advanced Editor when designing...
28 November, 2018
How to Present Information for Effective Dashboard Design
RON BARRETT (Audigy Group) Oracy is the ability to express oneself fluently and grammatically in speech. Literacy is the ability to read, write. Numeracy the ability to understand and work with numbers. Graphicacy is defined as the ability to understand and present information...
24 October, 2018
Bullet Chart Sparklines in Power BI
If the goal is an actual comparison, it's hard to beat the bullet chart. Highly efficient in terms of the amount of space they take up, with excellent data to ink ratio, they are both immediately intuitive yet data-dense without relying on...
28 August, 2018
Building Basic SVG Sparkline/Small-Multiples Measures in DAX
Sparklines and small multiples are incredibly powerful. They allow you to add a tiny simple graph to a table or a matric that conveys the basic idea or shape of the data in a way that is compact enough to allow for...
28 August, 2018
Building a DAX Time Intelligence Inspector
Creating and troubleshooting time intelligence measures in Power BI can be tricky work. Getting a measure to work at one granularity is hard enough, but when you start to look at rollup values it's difficult to be confident that you're getting the...
22 August, 2018
Bulk Rename Columns with Spaces in Power BI
A generally best practice in Power BI is to avoid naming columns in ways that won't make sense to users so things like CustomerFirstName should be broken out with spaces between the words. The problem is that when faced with a big...
18 August, 2018
DAX Percent of Total: A Visual Walkthrough
Getting a percent of total measure working in DAX, understanding how it's working in a non vague way can be quite a bit trickier. Really it is an ideal pattern to learn some of the underlying behavior of DAX. In this video, we...
11 August, 2018
DAX Year to Date: A Visual Walkthrough
When learning DAX, time intelligence formulas are an excellent place to start, and of the many formula patterns out there, “Year to Date” variations might be the best to learn first. The problem is, while writing them is fairly easy, understanding how...
10 August, 2018
Set A Custom Column Type in M with Zero Extra Steps
Custom columns are often the lifeblood of any M queries that you build. They give you huge amounts of power but by default remain untyped. You could add a step to type each new column after you create it, or even type...
23 March, 2018