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.

🔑 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

🚩Let’s connect on social:

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

[vijaykishan]

Hi Leila, can you please start making videos on Power BI with DAX and dashboards in Power BI.

[martinpaulbannister]

Thank you for this tutorial. Love power pivot and DAX measures. Your course is one of the best. So many learning objectives ticked off. Not sure if I’m the only one, but I prefer to build my measures with power pivot window being open, rather than clicking create measure. Need to get used to creating them your way, has I have busted started power bi. Thanks, Martin

[missaltay]

This was the first project that I was able to complete from start to finish, in a single sitting. So easy to follow along with. It took me 2 hours to complete, but I took so many notes and I finally understand the concept. You are a Rock Star! Love your teaching style... I am actually learning and retaining your information. Thank you from a Data Newbie!

[CeliaAlvesSolveExcel]

Brilliant, as always! Thank you, Leila!

[TylehurstXL]

Great Tip Leila! Make sure you do add this trick to your next dashboard people. I quietly added this functionality to a HR dashboard and the audience loved it !

[McKaySavage]

Really great! I’ve used this indispensable pattern many times in Power BI, but never thought to use it in Excel! Super smart technique!

[raafatgh]

Thanks Laila, I’m searching for this action since months and finally you shared this, however how ca i get support for other questions, appreciate your feedback.

[captainwalker]

Absolutely BRILLIANT!! Leila, you are pure Gold and Diamonds and all precious stuff! You're at the top of the three people I follow for Microsoft skills.

[esthercraft]

Amaziiiing Helpful Tips as always, is there a way we can create slicers to allow multiple Options to choose instead of just 1 option to choose in the slide also same method using DAX and Power Pivot for our Pivot Charts

[indzara]

Thanks for the video. This functionality is very useful in creating dynamic reports & dashboards. I have done this with formulas, pivots and slicers, but not with DAX and data model. Thanks for sharing.

[iv]

Finally 🙌 Dax measures, power pivot and dashboard tricks!!!
I need so much to improve this section.😢
Thank you very much, Leila. You are a saving angel.💕

[taizoondean]

Something New but little cryptic. Thanks for enlightening 👍

[sarush]

Great video as always.
Love the moderate pace, so it's easy to follow and great use of time stamps.
Great work, thanks

[HaiHaThanh-yr]

Hello, I've followed many videos on Youtube, thanks for your great works. Could you explain how to set relationship between 2 tables in this example?

[cenevspeed_CARS]

Leila, I would really like to Thank You for inspiring me to create content on YouTube! I had a YouTube channel before but did nothing, but thanks to your tutorials, I gained some fuel and created videos 🔥. People started liking my videos and even said that they are useful and I should keep it up 😀. Now I have reached 318 subscribers and I would like to thank you for helping me reach this point 👍🏼
And Great tutorial as always. Your thumbnails are improving by a lot 😎😎

[IvanCortinas_ES]

Tremendously creative Leila. Thank you very much for this breakthrough.

[pyclen]

Great video, will see if I can adapt this to a dashboard I am generating weekly
but learned so much watching your videos :-)

[sumisneaker]

Thank you for your educational content. I have a question regarding copying this to PowerPoint. Is it possible to create such a formula in Excel and use it within PowerPoint?

[surajbatra]

This is so clever, never though of it.

[m.fazlurrahman]

What is KPI? Key performance indicators; when it is to indicate with respect to a STANDARD, how can it be a count or sum or differentials to begin with. Now the slicers? It’s nothing but making custom functions ( complex/compound functions ) still without Measuring against a Standard. However, let’s say the table that you have to begin with, is from ONE “POINT” and you must have the same dataset from Multiple POINTs; to set KPI, either an “AVERAGE” or a “TARGET” FIGURE is a must have to call it a KPI. Now to justify the word “PERFORMANCE”; lets say for a particular POINT; The indicators are to be measured against the “ TARGET” or the “AVERAGE”. To view; many formatting options are available to choose from.