Posts filed under DAX

(Livestream Replay) Improving Models & Calculations in Power BI - with Jeroen ter Heerdt

Join Jeroen ter Heerdt (Program Manager - MSFT) as we discuss various topics under the umbrella of improving models and calculations in Power BI! We'll be diving into discussions around tables, relationships, model configurations / enhancements, DAX, design, and more! Tune in to find out!

GUEST BIO πŸ‘€

Jeroen ter Heerdt is a Program Manager with Microsoft. He works on Power BI and is passionate about "all things data"; whether it is about databases, data warehousing, BI, big data, data visualizations, self-service BI, advanced analytics, real-time BI or anything even remotely related to data or insight. He strives to apply these concepts in his life as much as possible. Jeroen combines enthusiasm, vision, and hands-on experience into his talks.

RELATED CONTENT πŸ”—

Jeroen's Blog
Jeroen's Twitter
Jeroen's LinkedIn

Changing a Report Tooltip Visuals Axis Field with a Slicer?!?

Learn how to leverage the functionality of Field Parameters to change the axis of a Report Page Tooltip visual. Based on the slicer selection on the main page, that then updates the visual on the report tooltip page. Tune in to learn more!

Video by: Reid Havens

RELATED CONTENT πŸ”—

Field Parameters Introduction

Download Report From The Blog Files Page

Customized Bar Chart Using a Matrix Visual + Conditional Formatting?!

Video by: Reid Havens & Gustaw Dudek

Learn how to create a customized bar chart (styled) visual with formatted totals using a native matrix visual in Power BI. This technique will leverage conditional formatting and DAX to reveal the hidden gems of the matrix visual!

GUEST BIO πŸ‘€

Gustaw Dudek works as Head of Business Intelligence at the Polish Company (Enterium). He has multiple years of experience in the field of data analytics and business intelligence. In addition he's one of the resident Enterprise DNA Experts, having created multiple showcase reports for various EDNA contests. Despite of designing most of showcase reports in dark-mode, Gustaw is a huge advocate of IBCS chart standards and really enjoys exploring both the art and science of report design.

RELATED CONTENT πŸ”—

Gustaw's LinkedIn
Gustaw's NovyPro

Download Report From The Blog Files Page

Building Your First Calendar Table in Power BI!

Video by: Reid Havens

Get a complete step-by-step guide to building out a dedicated calendar table and independent date hierarchy (using DAX) in Power BI. Tune in to learn more!

RELATED CONTENT πŸ”—

Date Hierarchy Types
DAX Vs. Power Query Date Table
Power Query Dynamic Date Range

Download Report From The Blog Files Page