Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Smart Excel Pivot Table Trick - Choose Your KPI from Slicer (Excel Dashboard with DAX). That video is uploaded by Leila Gharani at 2021-09-09T02:00:16-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [Q3YY1Ue9j-k]
| Name | Smart Excel Pivot Table Trick - Choose Your KPI from Slicer (Excel Dashboard with DAX) |
| Video Uploader | Video From Leila Gharani |
| Upload Date | This Video Uploaded At 09-09-2021 09:00:16 |
| Video Discription | Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-courses With Pivot Charts in Microsoft Excel you can add slicers to add interactive functionality to your dashboards. But what about adding even more interactivity? You could give the user the ability to change the relevant KPI in the chart from the slicer. In this video I'll show you how you can use Power Pivot and DAX to create a fully flexible chart for your interactive dashboard. You can use this technique to create disconnected tables in your Dashboards that you can use as slicers. You can connect these to multiple pivot tables and pivot charts as well. ⬇️ DOWNLOAD the workbook here: https://pages.xelplus.com/dashboard-trick-file 🔑 What You'll Learn: - How to create pivot charts with dynamic KPI slicers. - Step-by-step guide to adding data to the data model and using Power Pivot. - Techniques to manage and link slicers to pivot charts effectively. 👔 Perfect For: - Excel users seeking to add versatility to their pivot charts. - Professionals aiming to enhance their reports and dashboards. - Anyone looking to boost their Excel skills with advanced techniques. 🎯 Key Features: - Learn to create interactive pivot charts with flexible KPI selection. - Simplify your data analysis process by enabling quick KPI switches. - Make your Excel dashboards more user-friendly and adaptable. 00:00 How to Create Interactive Dashboards with Power Pivot and DAX 00:50 Adding Data to the Data Model 01:26 How to Add a New Measure in Power Pivot 03:09 Creating Slicer Selections 04:33 Add Measures for Slicer Selection 09:18 Insert the Chart with Slicers 12:03 Wrap Up Learn DAX: https://docs.microsoft.com/en-us/dax/ LINKS to more Excel Dashboard videos: https://www.youtube.com/playlist?list=PLmHVyfmcRKyz_4TwSfxzN_gsRtg3ODzyx ➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 🎥 RESOURCES I recommend: https://www.xelplus.com/resources/ 🚩Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/xelplus Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #excel Q3YY1Ue9j-k |
| Category | Education |
| Tags | XelplusVis | Leila Gharani | Advanced Excel tricks | Excel online course | Excel tips and tricks | Excel for analysts | Microsoft Excel tutorials | Microsoft Excel | Excel 2016 | Excel 2013 | Excel 2019 | XelPlus | Microsoft 365 | Excel 365 | dax | data model | excel dax measure | hasonevalue | write dax | slicer | excel dashboard | pivot table | pivottable trick | kpi in pivottable |
