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

[@LeilaGharani]

Struggling to manage your data? Learn Pivot Tables and save hours every week! 👉link.xelplus.com/yt-g-interactive-pivottable Grab the file I used in the video from here: pages.xelplus.com/dashboard-trick-file

[@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 !

[@missaltay718]

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!

[@snicho]

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.

[@LeilaGharani]

Glad you enjoyed it!

[@MichaelBrown-lw9kz]

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

[@LeilaGharani]

You're so welcome!

[@vverabing]

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!

[@LeilaGharani]

Awesome, thank you!

[@atta101md]

Thanks!

[@LeilaGharani]

Thank you!

[@richardcollinsuk6694]

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! :)

[@LeilaGharani]

Thank you so much! Glad to hear it's helpful.

[@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.

[@ramial-halabi4706]

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

[@LeilaGharani]

Thank you so much 😀

[@abbaskhalid5047]

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!

[@captainwalker]

Thanks

[@LeilaGharani]

Thank you, Russell!

[@iv1389]

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

[@LeilaGharani]

My pleasure, Iulia!

[@yusufbas035]

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

[@SheilaMills-lu5ju]

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

[@lalamalelang5670]

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

[@omotossso]

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

[@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!

[@Soulenergy31]

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

[@janicesmyth2183]

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!

[@LeilaGharani]

Wonderful!

[@ishugoyal1801]

Excellent way of describing concepts

[@354dw]

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

[@s.y.daniel2137]

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

[@ronaldyandell360]

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

[@AkobiSayaWamPipti]

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

[@CeliaAlvesSolveExcel]

Brilliant, as always! Thank you, Leila!

[@ScottLititz]

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!

[@imadhood]

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

[@alicehon1590]

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!!!

[@graemegourlay2850]

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

[@cenevspeed_CARS]

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

[@DFact13621]

Thank you, Leila. What an amazing trick.

[@taizoondean689]

Something New but little cryptic. Thanks for enlightening 👍

[@Voyager_AU]

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

[@vijaykishan8649]

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

[@RZing]

can't wait if you do make a course on that!

[@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.

[@riccardoczech6195]

I’m always mind blown by your videos 🥺

[@kennethvela2784]

Beautiful. Gave me great ideas to present my data

[@maricartoledo7532]

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.

[@1310kumarrakesh]

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

[@LeilaGharani]

Glad to hear that

[@jacobmnisi]

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

[@LeilaGharani]

You're very welcome!

[@naormadmoni8176]

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

[@LeilaGharani]

Have fun!

[@martinpaulbannister1745]

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

[@LeilaGharani]

Glad you enjoy it!

[@TheKrazzylover]

@@LeilaGharani if i wanted to show the data in % instead of the actual numbers, would it be possible?

[@rickclarke4529]

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!

[@LeilaGharani]

My pleasure, Rick!

[@Noble.Hustler]

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!

[@PedroMartins-bi9bl]

So well explained! Thank you for your videos!

[@LeilaGharani]

Glad you like them, Pedro!

[@dhanunjay99]

I dont have words to this work. Awesome😊

[@IvanCortinas_ES]

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

[@shashwatmishra3023]

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

[@LeilaGharani]

Most welcome 😊

[@SyedMuzammilMahasanShahi]

Thanks Leila for this beautiful video

[@LeilaGharani]

My pleasure 😊

[@yogeshsali]

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

[@LeilaGharani]

So glad!

[@xanthusbolt1509]

Hi Leela, A lovely and visionary idea Thanks

[@sarush1204]

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

[@LeilaGharani]

My pleasure :)

[@pyclen]

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

[@sivaprakasam6550]

Thanks you for sharing and fantastic DAX measures formula 😊

[@LeilaGharani]

Our pleasure!

[@EricHartwigExcelConsulting]

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

[@81siddharth]

You have amazing skills 👍

[@thenowbasket]

this is awesome!. Thank you!

[@mdwasitalinayyar]

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

[@LeilaGharani]

Thank you! Will do!

[@saleemtaj2647]

Radio looking very good with a very good lesson.

[@SamirHabib]

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

[@tiffanym8720]

so good video as always! Thanks Leila!

[@LeilaGharani]

Thank you! 😃

[@ricardowong1813]

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

[@mattschoular8844]

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.

[@LeilaGharani]

Glad it was helpful! More to come :)

[@haters9133]

@@LeilaGharani LAGU BUAT KPI & SJ! kzbin.info/www/bejne/i2KxpJeIiJKInpY

[@wayneedmondson1065]

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!!

[@LeilaGharani]

Thank you, Wayne! More to come on Power Pivot & Dax :)

[@jonathannali7682]

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

[@recipequeen7850]

just amazing work, thank you very much

[@prasannapriya7727]

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

[@LeilaGharani]

Glad you like it!

[@rhonalkhairul3969]

Thanks for this very amazing video

[@mohamadizhambinmohlis628]

This really help my reports. Thanks

[@kawaiigaming2537]

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

[@Seftehandle]

This is gorgeous like magic

[@sureshachary6840]

Thanks for this useful info.

[@hansklein3649]

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!

[@HachiAdachi]

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

[@jotacorredor]

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,

[@LeilaGharani]

You can download the workbook from the blog link in the description. It's on the bottom of the blog. That'll help with figuring out the formulas.

[@jeslovermusic578]

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

[@kncnsm]

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

[@hsh7677]

Leila is the best!!! Thank you!!

[@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

[@HaiHaThanh-y6r]

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

[@Verdexes]

Awesome video! Really helpful practice/intro to users trying to get into PowerBI as well

[@LeilaGharani]

Glad you like it!

[@sarienvanschalkwyk6318]

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.

[@LeilaGharani]

More to come :)

[@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.

[@rosesmary]

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

[@LeilaGharani]

Thanks. Soon 😊

[@benearmel6540]

Amazing video just as usual ☺️

[@LeilaGharani]

Thank you!! 😊

[@Meanna12]

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

[@szisziszilvi]

Simply lovely hack! :)

[@AbdulHaseeb-uz6rz]

Thank you so much Leila👍

[@goldendice2254]

very useful .Thanks for the efforts 👍

[@mahathmasadineni2884]

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

[@donnafigel8203]

Awesome video, it will help me take my dashboards to a new level! Thank you, you never disappoint in your videos 🤗

[@LeilaGharani]

Happy to hear that, Donna!

[@thinagaransiva7400]

Good end result but so complicated :):)

[@GeertDelmulle]

That is a nice little DAX lesson, very elegant! :-) Well done! This DAX-lesson format has many advantages over the Power Pivot interface format. Thank you very much! PS: in my understanding it doesn’t matter in which table you make your measures (I put mine in separate, dedicated table(s), since data tables may get replaced if they originate from power query, effectively deleting all measures inside their respective measure grids.

[@GeertDelmulle]

PS: your trick ‘only’ works if all KPIs have the same data type. ;-)

[@LeilaGharani]

True - a dedicated measure table makes it easier to find stuff. Also regarding data types - yes. A way around this is to add a cube formula to get the title for the chart. I guess we could also use a standard formula and a slicer that just captures which option is selected and we update the chart title to say "k $ Sales amount" or "number of orders" etc. Many thanks for your input Geert!

[@GeertDelmulle]

@@LeilaGharani Good suggestion to put the actual unit in the Chart Title, but it becomes tricky if you need quantities in whole numbers and Sales Amounts with 2 decimal places. :-) Then again: if the result is a table, we could use conditional formatting. But in an Excel Chart that functionality is not available, IMO.

[@LeilaGharani]

Agree - I tried with conditional formatting and also the Format function in DAX but it doesn't work in the chart. Just in the table. If the number of categories is fixed, we could probably extract the pivot data with formulas and then add a second series for the values - then use a standard chart over it.

[@GeertDelmulle]

@@LeilaGharani Well,… the formatting of the elements in the chart is done via the formatting pane, and there you can’t use formulas in the fields. OTOH, if you do find a way, then that would make for a great Breakthrough video! :-)

[@alexrosen8762]

Great stuff. Very useful

[@apexsmart6337]

This is creativity 😄😄

[@eslamreda159]

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.

[@susmitsen1588]

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.

[@Official_Debex]

This is really nice

[@ExcelWithChris]

What can I say....... brilliant!!!