Welcome to Part 9 and the final video of this second Power BI training series from Change Tips and Tools! In this video, I will show you how to add resource Drill Throughs to your report which allows your users to drill into another level of detail of the Capacity, Demand, Availability and Utilization data. Plus more tricks with DAX and Measures using functions such as COUNTROWS, DISTINCTCOUNT, CALCULATE and more!
Learn how to enhance the visual appeal of your reports and dashboards by customizing backgrounds with ease. This video will show you how to create stunning visuals for your PMO projects.
Join me in this tutorial to level up your Power BI game! Stay tuned for more insightful tutorials and don't forget to subscribe for updates on the latest Change Tips and Tools videos!
#excel #powerquery #powerbi #dataanalysis #datavisualization #pmo #fypage #howto
Delivered by @Changetipsandtools
Source materials for this video: drive.google.com/drive/folder...
Power BI - Series 2 playlist: • Power BI - Training Se...
This video contains:
00:00 - Intro
00:51 - Build the Capacity Drill Through page
04:47 - COUNTROWS Function
07:12 - The IF and ISBLANK Functions
09:04 - Use Matrix visual for Capacity drill through data
09:45 - How to create a hierarchy e.g. for Year, Month and Week in your tables
12:54 - Set up the drill throughs for the Capacity page
14:18 - Create the Demand drill through page quickly using shortcuts
15:07 - Capacity Page, update page navigation buttons
15:41 - Change the Data elements on the Matrix visual and filters for our Demand drill through
16:06 - Add a new slicer to filter on generic and none generic resources
17:32 - Change the Matrix visual to show Demand drill through data
19:03 - Create the Availability drill through page
19:39 - Demand Page, update page navigation buttons
20:03 - Update the Matrix visual to show Availability drill through data
20:41 - OOPS! - Almost forgot to add the Drill Throughs to the Demand page, lets do that now!
21:20 - Continue to update the Matrix visual for Availability data
22:59 - Add our Drill Throughs to the Availability page
23:33 - Create the Utilization drill through page
24:35 - Utilization Page, update page navigation buttons
25:02 - Change Matrix visual to show Utilization drill through data
26:41 - Review your draft report and make amendments where necessary
27:24 - Best practice always let your users know when the data was last updated
27:50 - Ensure consistency reference look and feel
30:09 - Change data labels on the Line visual to have a dynamic font based on utilization value
31:23 - Using DAX and Measures to make drill through cards more dynamic from a contextual perspective
32:31 - The DISTINCTCOUNT function
34:40 - The RELATED function
35:27 - The CALCULATE Function
38:24 - Publish your report
40:07 - You have a number ways that you can share your report with stakeholders
40:47 - What you should do before you share your new report
For the first Power BI training series follow Link to Budget vs Actuals Data Series playlist: • Power BI - Training Se...
Budget vs Actuals Excel Dashboard Playlist: • Budget vs Actuals Data...
Resource Capacity Planning in Excel Playlist: • Resource Capacity Plan...
Негізгі бет Тәжірибелік нұсқаулар және стиль Power BI Secrets: Drill Throughs, Measures, and DAX
Пікірлер