Tag: DAX Measures

DAX Query Optimization Techniques And Lessons

DAX Query Optimization Techniques And Lessons

This tutorial will discuss about DAX query optimization practices. You’ll learn what VertiPaq can do with caches to improve DAX performance and generate accurate results. VertiPaq Caches In DAX Calculations The first topic is the VertiPaq Cache. Before you run your queries, you have to clear the cache first because other users may not use

Continue reading

Use Measure Branching To Speed Up Report Development

In this tutorial, I’m going to show you how I maximized a technique called measure branching to speed up my report development process on my submission for the 10th Power BI Challenge. The Power BI Challenge is a series of scenarios where a data set is provided and participants are asked to deliver the set

Continue reading

Power BI Donut Chart: Custom Visualization Tutorial

In this tutorial, I’ll talk about the Power BI donut chart. Most people don’t like donut charts and there are valid reasons for their dislike. First, you cannot put many categories on a donut chart. They also don’t look good at all, and can be inconvenient to use. However, as I was playing around with

Continue reading

Power BI Scatter Chart: Conditional Formatting

Power BI Scatter Chart- Conditional Formatting

In this tutorial, we’ll discuss how to creatively use a Power BI scatter chart. We’ll also tackle one of its limitations and how we can deal with it. A scatter chart, also known as scatter plot, uses a series of dots to represent data. This type of data visualization is used in showing the relationship

Continue reading

Table Visual In Power BI | Dynamic Subsetting

Table Visual In Power BI | Dynamic Subsetting

I want to spend some time today going through a question from Enterprise DNA member, Lucas about table visual in Power BI. It’s an interesting question in of itself, but I want to dissect it because it also touches on a bunch of other interesting topics, including disconnected tables, slicer harvesting, and some slicer visualization

Continue reading