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 🔗

BECOME A CHANNEL MEMBER 🎉

CHECK OUT OUR MERCH STORE 👕

LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟

VIDEO CHAPTERS 🎥
0:00 - Start of Video
0:30 - Content Intro

HAVENS CONSULTING PAGES 📄

EMAIL US AT 📧

#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #filters #slicers #visualization

[redlegcraig]

This was very helpful as I was recreating an existing report that had a single value input field. At first I just copied the DAX that created the table, so I didn't have the Single Value option when formatting my slicer. This video showed how to insert a table as a what if parameter. Thanks!

[johnewers]

I'm looking to do a search on a text field. Is this possible w/ a user prompt?

[AdolfoHernandez-qp]

Great video! Do you have to buy a license of Tabular Editor 3 to apply this solution?

[ashleyg]

I saw someone in the comments ask the same question but did not get a response. So how did you create the input field on 4:08?

[samuelkrall]

Great video, implemented. easily in one of my reports.

Also what type of visual is that multi-dimensional pie chart???

[NirdeshM]

i am looking for input field from where user can supply the value, is this same?

[premcst]

Show me some one who can explain it better !!