Power Query - Use Excel Slicers as Power Query Parameters

Video Description

Learn how to create a process that will take Excel Slicers as input to Power Query and use the selections as filters for data. Video for "Faster and Easier Parameters": https://youtu.be/-ibpZWeqzTI File Download Link: https://www.bcti.com//wp-content/YT_Downloads/BCTI_PQ_SliceParam.zip 00:29 The Problem with Slicers and Power Query 00:53 Slicer to Power Query Process (Overview) 02:27 File Download Instructions 02:38 Setting Up the Data Table (tblSales) 02:49 Setting Up the User's Input Page 03:15 Creating the Pivot Tables 04:13 Naming the Pivot Tables 04:43 Building the SLicers From the Pivot Tables 05:30 Testing the Slicers Against the Pivot Tables 05:52 Adding the VBA Code Used to Extract Pivot Table Data 06:52 Creating VBA Output Tables 07:31 Matching the Output Table Names to the Pivot Table Names 07:53 Testing the VBA Code Against the Rest of the Project 08:52 Reading the VBA Output Tables into Power Query as Lists 10:29 Creating Query Groups (Query Folders) 10:54 Get the Data as a Full Query Table 12:15 Get the User's Selections 14:22 Converting the Tables to Lists 15:03 Implementing the FIlters (Statically) 15:51 Converting Static Filters to Dynamic Filters 18:19 Sending the Output Back to Excel 18:40 Generating a Proper Table of Results on a New Sheet 18:52 Testing the Output Table with the Slicers and VBA Code 19:36 1 Macro to Both Update Slicer Tables Output and Refresh Final Table 21:06 Process Summary