Posts filed under 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

Fiscal Periods Time Intelligence Slicer in Power BI

Video by: Reid Havens

Part four of four in a series - learn how to leverage relationships and DAX calculated tables to create a time intelligence slicer with fiscal periods in Power BI. The end result will perform faster and create a better user experience versus needing to create many time intelligence DAX measures.

RELATED CONTENT 🔗

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

Posted on March 30, 2021 and filed under DAX, Power BI, Slicers & Filters, Intermediate.