Smart Excel Pivot Table Trick - Choose Your KPI from Slicer (Excel Dashboard with DAX) 

Grab the file I used in the video from here 👉 pages.xelplus.com/dashboard-trick-file

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

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!

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 !

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.

Loved being able to add a slicer to the data model. This looks so cool, thank you for sharing.

I just stumbled upon on one of your video some days ago and now I am hooked on to your channel like a junkie. From using excel formula's to coming up to Power Query I enjoyed and learnt from every video i watched. Treat to watch and learn with your interactive style. The best thing is you refer others who are doing the same work as you are. Amazing and wonderful! keep it up!

There's lots in this video; but you present it well, Leila. It's well structured, well paced, and has just enough explanatory commentary. A very useful, real-life example! Thank-you.

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

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.💕

Leila, I would really like to Thank You for inspiring me to create content on RU-vid! I had a RU-vid 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 😎😎

OMG Leila this is exactly what I needed to de-clutter my dashboard, what an amazing trick! You truly are an Excel Goddess! Thank you for sharing your exceptional skills with us, I have learned so much from you and it’s hugely appreciated, by me and my employer who now think I’m an Excel God too! :)

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

Лейла Гарани как всегда на высоте. Спасибо большое!

Wow. This is one video that has to be marked as saved. There is so much good info in it, I know I'll keep referring to it again and again. Thank you, Leila!

My goodness this video is unbelievable. WOW. Now I see how I can apply the SWITCH function. Thank you so much Leila

This is amazing. I can’t get budget to rollout powerBI just yet. this will really help in the meantime. Thank you.

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.

This is the kpi. I did not know this. Now I know how to use it Kpi. Thanks for sharing. Ilwill practice it. This.

Something New but little cryptic. Thanks for enlightening 👍

Brilliant, as always! Thank you, Leila!

I've been looking for this for two days; I appreciate you.

thank you for making me alot harder to replace in this competitive corporate world!!

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

No word to say.....A very Great Effort and contribution

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

Excellent way of describing concepts

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.

Cant thank you enough for this awesome trick Leyla!!!!!!!! Blessing Sunday!!

This is brilliant. I'd never though of using measures in this way. Going to be using this.

Thank yo so much Leila! I've been desperately looking for tutorials on this and here I found exactly what I need. I've been a fan of yours and now I'm a even bigger fan 😀👍👍👍 Thank you thank you thank you!!!

Amazing video, Leila! You're awesome! Thank God I can understand English; otherwise, I would be stuck with only Portuguese videos.

Thank you, Leila. What an amazing trick.

Power Pivot is great! Thank you for your understandable videos!!!

You're gonna make me look too important at work, not knowing it's completely you. Thanks for always

Thank You so Much Leila for this amazing tutorial❤ ... I have a question can I change the cell formatting according to our needs in this case suppose in kpis we want to show total sales quantity ordered and total footfall now for sles we qant to shows the kpis as accounting format and for qty and footfall whole number format is it possible to do this

Thank you, Leila. I have been using this technique in Power BI, but I didn't think to also use it in Excel for some reason... and I'm crossing my fingers that someday Excel DAX will let us use SELECTEDVALUE function...

New formulas and tricks learnt! Will apply on my reports right away ! !!

Amazing video! Now a single large chart can show all the KPIs for a project! I would have had a separate chart all stuffed on one page. This is SOO much better. Thanks!

This is outstanding! I love learning all of these tricks. I just need to to put it all together into dashboards. I need to practice so much .....

I’m always mind blown by your videos 🥺

thank you Leila for making this fun. I've been doing a few of these and feel so smart when I show my grandkids. They subscribed too!

Thanks from the bottom of my heart, It's really great help God Blessed You where ever You are.

Hi, Thank you for sharing the knowledge, Could you please let us know what is Excel Version are you using?

Thanks.One of the easy to follow content on power pivot. Madam could please upload content on calculated column and measures with example, pointing the difference between the two. It will be highly appreciated.

I dont have words to this work. Awesome😊

this is awesome!. Thank you!

Hi, thank you for sharing this is what I need to learn. Mostly job post for data entry should know how to create KPI's standard.

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?

Thank you so much, this is very helpful and educational, I now understand excel better because of your videos, once again thanks

Beautiful. Gave me great ideas to present my data

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

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

awesome! already after 2:33 minutes I have to pause this video to like and commend. Because I already learned so much!! so helpful with the "measures" that I can create myself. So much more robust than adding thousands of columns with measures in the table itself. thanks!

As usual i always learn something new through ur videos, thankx and god bless you.

Omg, you just blew my mind!!! Can’t wait to learn power pivot 😁

Thanks you for sharing and fantastic DAX measures formula 😊

So well explained! Thank you for your videos!

Are we sure Leila isn’t some Advanced AI PROGRAM but rather a human? By far the best Excel content on the internet barn-one! And as accounting CPA in the States, it’s my #1 spot for soliciting excel ideas when attacking a new case at work….and believe it or not, that little stunt alone has really worked magic and stunned bosses & masses alike!

Thanks Leila, found this very helpful. Please update more videos on Dax

Hi Leela, A lovely and visionary idea Thanks

Hola Lelia, I really appreciate your short videos. I had learned a lot and everything you teach is true!! Please keep posting videos with this quality!!!! Please post a video of what suggesting a good computer

Thanks Leila for this beautiful video

Most awaited video for 9 to 5 job guys... It's great .. really helpful.. thanks a lot... 👍

This really help my reports. Thanks

This is a great hack! I actually pivot all my measures into a single Measure via powerquery so I can have just 4 measures (Actual, Budget, Forecast, Prior Year) which helps make VTF, VTB, & Y/Y calculations much easier to manage

Radio looking very good with a very good lesson.

I think this is the first vedio available on this concept...

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

Super awesome! Thank you so much for creating/sharing this video!

Leila.. what a wonderful information.. each and every time you came with new ideas which help me lot to increase Excel knowledge. ❤️

This is gorgeous like magic

Thanks Leila, this is very helpful. Can we do it similar for row filelds, Product, Salesman name, State...etc🙏

Thanks for the trick! Is there a way to make the Pivot table rows switch as well when you select the KPI? For example, I am trying to show the demographics of viewers. The KPI's are the number of viewers location and the industry.

Awesome. We need more of the DAX tricks. This is very helpful

Thanks for this very amazing video

Thank you so much for very informative videos. You helped me a lot. 😉

just amazing work, thank you very much

Leila, Thank you so much for the wonderful videos. I have one tough problem here. How can i use slier to show or hide multiple charts coming from multiple Pivot tables? Tableau is easy, using parameters. But how about excel?

Had some trouble as I'm more used to excel in Spanish but I'll apply a couple of tricks learned today. Thanks for sharing. Slds,

Leila, It is always a pleasure to watch your videos on RU-vid or Udemy. You guided & inspired me on how to create interactive dash boards. can you include Power BI

Thanks for this useful info.

Another awesome tutorial. I wish you have a course for DAX and power pivot

I use DAX in PBI only, but this is a great example how Excel charts can be interactive.

Hi leila . Thanks for all your work. Can you please make a video about your you choose a random sample from a column. Thanks again.

Hi Leila, Thanks for the video. It's indeen an eye opening for amateur like me. However, I just wonder, is it possible to do grouping in Data Model Pivot table?

Your tips are often so interactive or dynamic, that one becomes excited or at least more interested of excel. The undiscovered possibilities of solving problems with creativity are nearby endless!

so good video as always! Thanks Leila!

Thanks Leila. There is some good info in this one so I am going to need to watch this one again when I am at my laptop..Thanks for sharing. More DAX/PP videos would be appreciated as there are so many measures to learn.

I am on a mission to follow you until I learn Excel. Thank you very much

Leila, you are a phenomenal trainer. Just loved the tutorial. When are you going to launch this course on Udemy?

Simply lovely hack! :)

Leila is the best!!! Thank you!!

Thank you so much Leila👍

Awesome Leila! Timely for me as I'm just now doing more with Power Pivot / Power BI and DAX. That's a great slicer trick and lots of other good tips too! As always, thanks for sharing :)) Thumbs up!!

Great info! I'm fairly new to DAX, so this was a bit too advance for me. Really want to learn it though, so more on these will be appreciated.

very useful .Thanks for the efforts 👍

Very helpful!

Fantastic method

Thank you very much. It is a very useful and powerful technique.