Choose Your KPI from Slicer (Using Power Pivot & DAX ) in EXCEL- Smart Excel Pivot Table Trick
Choose your KPI from Slicers Using Power Pivot & DAX in Excel
Get the ability to change the relevant KPI in the chart from the slicer.
Until now we have created pivot tables and pivot charts along with the slicers that helped us breaks down further by say product count & another pivot for say #orders and so on. But imagine a chart which lets you switch/toggle between the KPIs of your choice? Isn't that wonderful especially while making and interactive dashboards for client. This can be done using Power pivot and adding DAX.
So, let's see how you can set this up by adding Data to the Data Model.
Let’s learn how you can use Power Pivot and DAX to create a fully flexible chart for your interactive dashboard.
The key step in this process is to employ Excel's data model which allows you to create relationships between the different data sources.
Link to download the data file : https://docs.google.com/spreadsheets/...
My short on slicer: • Excel Slicers to filter, slice & dice your...
My Video on Pivot: • PIVOT TABLES- All you need to know I MS Ex...
Thanks for watching this tutorial, don’t forget to like, comment & share it with your friends.
🔔 SUBSCRIBE ON YOUTUBE:
ҠąӀքąղą PⱮ 😎: @KalpanaPM_DataIsVital: / @kalpanapm_dataisvital
🔽 CONNECT WITH ME
LinkedIn: / kalpana-magar-350156232
Facebook: / kalpana.magar.940
Instagram: / kalps_pm
#msexcel #exceltips #exceltutorials #excelformulas
#excel #exceltutorial #exceltips #exceltricks #exceltrick #excelsupport #msexcel #msexceltricks #microsoftexcel #microsoftexceltutorial #excelfunction #excelfunctions #msexcelformulas #viral #viralvideo #viral_video #trending #trendingvideo #trendingstatus #trendingtutorial #trendingvideos #spreadsheets #corporate #excelspreadsheets #workhacks #sheets #excelshortsvideo #excelsheets #finance #accounting #excelguide #filters #slicers #pivot #dax #measures #powerpivot #dashboardsnoexcel #slicers