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

(Livestream Replay) What's new in DAX Studio 3? - with Darren Gosbell

Join Darren Gosbell and I for this live stream and hear about what is new and improved in DAX Studio 3! You’ll discover lots of amazing new capabilities, U/I improvements, feature enhancements, and even DARK MODE. Tune in to learn more!

GUEST BIO 👤

Darren Gosbell is a Senior Program Manager on the Power BI Customer Advisory Team with a passion for Data Visualization and Data Modelling. He has been working with the Microsoft Data Platform since 1999 and has practical experience implementing data warehousing and business intelligence solutions for some of Australia’s largest corporations. Prior to joining Microsoft Darren was awarded as a Microsoft Data Platform MVP from 2006 to 2022 in recognition of his contribution to the community especially in the areas of Analysis Services and Power BI, MDX and DAX. Darren is a contributor to a number of open source projects including DAX Studio, BI Developer Extensions (formerly called BIDS Helper) and ASStoredProcedures.

RELATED CONTENT link🔗

DAX Studio
Darren's Website
Darren’s Twitter

(Livestream Replay) Improving Models & Calculations in Power BI - with Jeroen ter Heerdt

Join Jeroen ter Heerdt (Program Manager - MSFT) as we discuss various topics under the umbrella of improving models and calculations in Power BI! We'll be diving into discussions around tables, relationships, model configurations / enhancements, DAX, design, and more! Tune in to find out!

GUEST BIO 👤

Jeroen ter Heerdt is a Program Manager with Microsoft. He works on Power BI and is passionate about "all things data"; whether it is about databases, data warehousing, BI, big data, data visualizations, self-service BI, advanced analytics, real-time BI or anything even remotely related to data or insight. He strives to apply these concepts in his life as much as possible. Jeroen combines enthusiasm, vision, and hands-on experience into his talks.

RELATED CONTENT 🔗

Jeroen's Blog
Jeroen's Twitter
Jeroen's LinkedIn

Changing a Report Tooltip Visuals Axis Field with a Slicer?!?

Learn how to leverage the functionality of Field Parameters to change the axis of a Report Page Tooltip visual. Based on the slicer selection on the main page, that then updates the visual on the report tooltip page. Tune in to learn more!

Video by: Reid Havens

RELATED CONTENT 🔗

Field Parameters Introduction