Posts filed under Slicers & Filters

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.

Creating a Calendar Slicer from a Matrix Table! (with Erik Svensen)

Video by: Reid Havens

Join Erik Svensen and I as Erik walks through how to transform a native matrix visual into a powerful Calendar type filter for your visuals! Where you can slice by date, day of week, week period of year, and more. Tune in for the demo!

GUEST BIO (Erik Svensen)👤

Erik Svensen is a Microsoft MVP. Erik has been working with the Microsoft BI stack for more than 20 years - starting with out with Excel and Microsoft Query for over 25 years ago. He owns the company CatMan Solution who is now serving over 70+ FMCG suppliers with a Power BI solution that provides the supplier with valuable insights in their performance at store level based on point of sales data provided to them by different retailers. He started the Danish Power BI User group and speaks at conferences and meetups. Another great passion besides Power BI is his collection of Danish contemporary art. And if he finds time he occasionally blogs about Power BI as well.

RELATED CONTENT 🔗

Erik's Blog
Erik's LinkedIn
CatMan Solutions

Cross-Highlighting a Visual Using a Slicer ?!?

Video by: Reid Havens

Learn how to leverage some recent native visual features plus a little bit of [DAX] magic to use a slicer to create a cross-highlight effect on a visual. Cross-highlighting is normally only natively available between visuals, not slicers. So tune into learn more!

Posted on July 2, 2024 and filed under Slicers & Filters, DAX, Visualizations.