Posts filed under Slicers & Filters

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

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

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.

Dynamically Filter Page Navigation Per User With Row Level Security (RLS)

Video by: Reid Havens

Learn how to utilize row level security (RLS) to filter page navigation options for each user by using page navigation buttons and slicer selections in Power BI.

RELATED CONTENT 🔗

Conditional Page Navigation for Buttons in Power BI