Posts tagged #Field Parameters

Power BI Field Parameters vs Calculation Groups (Clear Comparison)

Video by: Reid Havens

In this video I walk through the Field Parameters vs Calculation Groups Guide from Analytic Endeavors and explain what these two powerful Power BI features actually do, how they differ, and when to use each one in your reports.

You’ll learn:

  • What Field Parameters are and how they let your users choose what to show in visuals

  • What Calculation Groups are and how they let you change how measures calculate dynamically

  • The key decision points between using FP and CG

  • How each feature affects report design, maintenance, and flexibility

This is a conceptual walkthrough, not a step-by-step build. The goal is to help you understand the behaviors and tradeoffs so you can pick the right tool for the problem you’re solving.

Dynamic Matrix Columns in Power BI: Show/Hide Based on Row Hierarchy

Video by: Reid Havens

Ever wish your Power BI matrix could respond intelligently to what’s visible in the row hierarchy? In this video, I’ll show you how to create a dynamic matrix where column values, like department, title, or other employee attributes appear or disappear based on what’s selected in your row-level hierarchy.

We’ll combine a few clever modeling tricks to keep your matrix clean, relevant, and user-driven. Tune in to learn more!

RELATED CONTENT 🔗

Field Parameters in Power BI

Posted on July 29, 2025 and filed under Visualizations.

Using Paired Columns in Power BI Field Parameters for Accurate Grouping

Video by: Reid Havens

Field parameters in Power BI offer powerful flexibility when using them for custom visual hierarchies. However, certain columns shouldn’t be used alone, especially when they’re part of a hierarchy or grouped relationship. In this video, I demonstrate how to create a field parameter setup that ensures key columns are always selected together. This approach avoids misleading rollups and duplicated values in matrix visuals, keeping your reports accurate and intuitive.

RELATED CONTENT 🔗

Field Parameters in Power BI

Posted on May 20, 2025 and filed under Slicers & Filters, Power BI, Power BI Features.

Bookmarks + Field Parameters = Better Hierarchy Controls!

Video by: Reid Havens

Learn how to combine Bookmarks with Field Parameters to give users the option for one-click hierarchy configurations but also custom hierarchy level ordering for advanced configurations. Tune in to learn more!

RELATED CONTENT 🔗

Creating Bookmarks
Field Parameters

Posted on April 22, 2025 and filed under Slicers & Filters, Power BI, Reporting.