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

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

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