Dumbbell Charts: Custom Visual Vs. Charticulator

In this tutorial, we’ll discuss the not-so popular visual in Power BI called Dumbbell charts. A Dumbbell chart is commonly used to show comparison between two or more groups of data points. This is also sometimes called a DNA chart. Here’s an example of a dumbbell chart. This is created with Charticulator, and not with

Continue reading

Best Practices For Power BI Report Development

Best Practices For Power BI Report Developme

Over the last few months, I presented several tutorials, showcasing best practices for Power BI report development for each of the four pillars of Power BI. In this blog, I wanted to take this opportunity to present my personal top 10 list. You may watch the full video of this tutorial at the bottom of

Continue reading

Optimizing Queries For A Faster DAX Performance

Optimizing Queries For A Faster DAX Performance

This tutorial will talk about optimizing your queries in DAX Studio. You’ll also learn how to mitigate the presence of the CallBackDataID if ever they appear in your calculations. This will help improve DAX’s performance in generating accurate data. If you recall from previous blog posts, CallBackDataID appears when the storage engine asks help from

Continue reading

Iterators and Context Transitions In DAX Queries

Iterators and Context Transitions In DAX Queries

This tutorial will discuss context transition and nested Iterators. You’ll learn the importance of these entities and how they can be a good source for optimization. If you recall, context transition happens when a row context changes into an equivalent filter context. You need to be aware of what’s happening when a context transition occurs

Continue reading

DAX Queries Using Variables And Important Functions

DAX Queries Using Variables And Important Functions

This tutorial will discuss about variables, including the FILTER and CALCULATE functions. You’ll understand how these help boost the performance of your DAX queries and provide accurate results. Variables should be used as much as possible because they can easily locate codes for optimization. They prevent you from getting incorrect outputs and save you time

Continue reading