Posts filed under Slicers & Filters

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.

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