Posts filed under Slicers & Filters

Create a Multi-Selection Drillthrough "Button" in Power BI

Video by: Reid Havens

Learn how to create a "button" with right-click Drillthrough functionality using single value cards in Power BI. This works great when selecting multiple rows from a matrix table, or multiple selections from other visuals.

RELATED CONTENT 🔗

Power BI Drill Through using Multiple Data Points

Download Report From The Blog Files Page

Improving the Time Intelligence Slicer & Avoiding Circular Dependencies

Video by: Reid Havens

I've improved my time intelligence slicer based on some feedback about a DAX error related to blank dates being evaluated. In this video we'll see how to avoid that plus also prevent any circular dependency errors as well!

RELATED CONTENT 🔗

Part 1: Creating MTD/QTD/YTD Filters
Part 2: Applying USERELATIONSHIP Function
Part 3: Additional Date Periods
Part 4: Fiscal Periods

Download Report From The Blog Files Page
Posted on September 21, 2021 and filed under DAX, Power BI, Intermediate, Slicers & Filters.

Integrating Time Intelligence Filters with Drillthrough in Power BI

Video by: Reid Havens

Learn how to combine a Time Intelligence table with a matrix visual to propagate date filters through a Drillthrough action in Power BI.

RELATED CONTENT 🔗

Part 1: Creating MTD/QTD/YTD Filters
Part 2: Applying USERELATIONSHIP Function
Part 3: Additional Date Periods
Part 4: Fiscal Periods

Download Report From The Blog Files Page

Advanced Slicer Selection Reset For Drillthrough Pages

Video by: Reid Havens

Learn how to leverage a bit of bookmark magic to clear/reset slicer selections on a drillthrough page. Even when those slicers have no association with any of the drillthrough filters.

Download Report From The Blog Files Page