Posts tagged #Slicers

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

Download Report From The Blog Files Page
Posted on May 20, 2025 and filed under Slicers & Filters, Power BI, Power BI Features.

Fixed-Window Charting in Power BI: Auto-Adjusting Calendar Periods

Video by: Reid Havens

Learn how to create a chart that always displays the same number of calendar periods, driven by slicer period selection, and regardless of if there is existing data (yet) for a period. This leverages a [DAX] generated table, relationships, and some auto-magic features. Tune in to learn more!

RELATED CONTENT 🔗

Creating a MTD/QTD/YTD Time Intelligence Slicer

Download Report From The Blog Files Page
Posted on January 28, 2025 and filed under DAX, Data Modeling, Visualizations.

Creating a Dynamic Label Toggle Button Using ONE VISUAL!

Video by: Reid Havens

Learn how to leverage the newer tile slicer (thanks #PBICoreVisuals Team!), a bit of [DAX] Magic, and some clever techniques to create a single button toggle slicer using only a single visual! Plus, this single button even has a dynamic (on/off) label. Tune in to learn more!

RELATED CONTENT 🔗

Microsoft Learn: Field Parameters
Button Slicer

Download Report From The Blog Files Page
Posted on January 7, 2025 and filed under Visualizations, Power BI.

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!

Download Report From The Blog Files Page
Posted on July 2, 2024 and filed under Slicers & Filters, DAX, Visualizations.