Posts filed under Slicers & Filters

Different Approach to a Auto-Scaling Date Axis in Power BI

Video by: Reid Havens

Learn about an updated technique I applied after getting inspiration from another YouTube video showing this original technique. This approach achieves the result of a dynamic date axis that scales to your filtered date range, but with less model additions than the original approach. But while still using Field Parameters and some clever DAX. Tune in to learn more!

RELATED CONTENT 🔗

Original Technique (SMART Axis Magic)

Two Ways to Create Single Value Input Slicers in Power BI!

Learn about two techniques for creating a single value input Slicer in Power BI Desktop!

The first method will apply a technique outlined in a SQLBI article (link below) that uses Tabular Editor to allow native columns (fields) to be modified to allow single value slicer types to be used with them. One consideration is that this technique is not officially supported by Microsoft.

The second method shows you an officially supported method for adding a single value input slicer. This alternative way implements a WhatIf parameter and leverages some clever DAX and relationships to achieve the same result.

RELATED CONTENT 🔗

SQLBI Single Value Slicer
HTML Content Viewer (Daniel Marsh-Patrick)

Video by: Reid Havens

Alternative Ways to Drillthrough with Hyperlinks in Power BI!

Learn how to leverage hyperlinks and apply filters to navigate to Drillthrough-like pages in Power BI. This alternative approach also has considerations on design and implementation which we'll discuss at length. Tune in to learn more!

Video by: Reid Havens

Posted on October 4, 2022 and filed under Intermediate, Slicers & Filters, Power BI Service.