By Andrew Gould

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

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!

In this video you'll learn how to use the value selected in a disconnected slicer to apply conditional formatting to visuals in a report. You'll learn how to test if columns have been filtered or cross-filtered, how to return single or multiple selected values and how to return colours using names or hex codes.

Chapters
00:00 Topic list
00:54 The Basic Report Setup
01:52 Creating a Disconnected Slicer
05:15 Comparing the Selected Values
07:07 Calculating a Colour
09:35 Dealing with No Selection
12:11 Dealing with Multiple Selections
14:07 Checking if a Column is Filtered
16:01 Using a Slider Bar
16:54 Disconnected Slicers for Text Fields
18:29 Conditional Formatting with a Measure
20:35 Disconnected Date Slicers
23:25 Conditional Formatting with Dates
25:07 Testing for Cross Filters
28:43 Choosing Colours from a Slicer
31:01 Returning a Colour in a Measure
32:52 Using a Chart to Pick Colours

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!