By Andrew Gould

Download files here https://www.wiseowl.co.uk/power-bi/videos/dax-powerbi/disconnected-slicers/

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join

Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

This video explains how to use slicers to pick values without filtering visuals in a report. You'll learn how to add a disconnected table to the data model and how to populate a slicer with fields from it. You'll use the SELECTEDVALUE and VALUES functions to return the items picked in the disconnected slicer and then use the returned values in measures to compare against other values. You'll learn how to set up the slicer to allow for multiple selections or single selections only. You'll also see a few examples of using measures to apply conditional formatting to visuals and create dynamic titles.

Chapters
00:00 Topic list
00:42 What are Disconnected Slicers
02:35 The Basic Report Setup
04:09 Creating a Disconnected Slicer
07:31 Returning the Selected Value
10:09 Comparing with the Selected Value
12:10 Formatting the Results
17:02 Testing if a Value is Selected
19:54 Comparing with Multiple Values
22:14 Forcing a Single Selection
23:59 Adding an All Option
27:52 Testing for the All Option
29:35 Creating a Dynamic Title
36:15 Displaying Results in a Chart

Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!