Smart Excel Pivot Table Trick - Choose Your KPI from Slicer (Excel Dashboard with DAX)
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.
★★★ My Online Excel Courses ►
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:
⯆
2 views
1307
434
9 hours ago 00:08:50 1
Inside a Stunning $6,970,000 Dubai Beachfront Penthouse with Pool & Cinema!
2 days ago 00:01:35 1
Lenovo Auto-Twist AI PC Concept: Redefining Focus, Uniquely Centered Around You.
5 days ago 00:15:30 1
Best Crypto Wallet | Top 5 Crypto Wallets | Crypto Wallets