Tag: Power BI Filters

Introduction to Filter Context in Power BI

Filter context is one of the major topics that any Power BI user should initially learn about, especially if you want your DAX calculations to work effectively. In this article, I will run through the filter context. Every DAX formula is calculated in a two-step process. DAX Formula: A Two-Step Process The first step is

Continue reading

Comparing Calculated Columns And Measures In Power BI

Measures vs Calculated Columns In Power BI

In this tutorial, I will cover the two places where you can write your DAX formulas. These two places are the calculated columns and measures. I will go over each one at a time and I’ll start with calculated columns. Using Calculated Columns A calculated column is an additional column that doesn’t exist in your

Continue reading

Power BI ‘What-If’ Parameter Feature

Power BI New Feature What If Parameters

Power BI What-If parameters are a really powerful feature to implement in your models for scenario analysis. Scenario analysis is immensely important from an analytical perspective in Power BI and ‘What-If’ parameters allow you to quickly implement tables and measures for this type of analytics. Once you select the What-If parameter icon, it opens a

Continue reading

Power BI Query Parameters: Optimizing Tables

Query parameters are a really strong feature in Power BI. There are many places that you can implement filters in Power BI, but on some occasions, it’s better to do this at the query layer versus the report level. You might want to create filters at the query level if you have massive tables from

Continue reading

Using Filter Fields & Visual Interactions To Create Compelling Visualizations In Power BI

I want to show you how you can use filter fields and visual interactions in Power BI to great effect. They create simple and very effective ways to make your visualizations easier and more intuitive for the consumer especially if we need to create groupings of information in our analysis. Filter fields enable you to

Continue reading