Channel Title: P3 Adaptive Channel Description: www.p3adaptive.com: PowerPivot and Power BI Training, Consulting and Blog <video> Add Visual Flare In PBI With Background Colors Description: Video by Reid Havens - Founder of Havens Consulting and contributing author at P3 https://www.havensconsulting.net Learn how to add page and visualization backgrounds to add a touch of visual flare to your reports. For other great reporting techniques check out my video on how to transform Power BI Reports from Good to GREAT. https://youtu.be/3Cq5W-KzJL0 </video> <video> Excel to Power BI: Webinar Recording 2015-09-22 Description: Check out http://ppvt.pro/p3webinar for future Webinar Events by PowerPivotPro. See this page for quick links to jump to topics covered in the webinar...http://www.powerpivotpro.com/2015/10/power-bi-sep-22-webinar-recording-and-signups/ </video> <video> Power BI Feature Spotlight: Using Bookmarks to Create Pop-Up Windows Description: Video by Reid Havens - Founder of Havens Consulting and contributing author at P3 https://www.havensconsulting.net Hello P3 Nation, welcome back to another exciting month of Power BI updates! This month’s release saw quite a few new updates and enhancements to the Power BI Universe. It’s like Christmas each month for us here at PowerPivotPro, where we get to open the latest updates article and see what the Microsoft Santa brought us this month. Data enthusiasts like us (and you!) can easily get swept up in all the bells and whistles features each month. That’s where we come in. We’ll pass on to you our favorite new features each month. Before I discuss my favorite feature(s) this month, let me first give a nod to the honorable mention updates. One really useful update was the new DAX function COMBINEVALUES(). It’s a great move forward for Direct Query Models where multi-key relationships weren’t part of query folding previously…but now they can be! It’s also a great way to write a cleaner version of a nested CONCATENATE() DAX function.... Read More At PowerPivotPro.com </video> <video> Power BI Finance Dashboards (Webinar Recording) Description: See Page for Quick Jump Links to each Section: http://www.powerpivotpro.com/2016/08/watch-the-power-bi-webinar-recording-aug-16/ Se page for more detail on the Financial Dashboard: http://www.powerpivotpro.com/2016/07/using-power-bi-build-financial-dashboards/ Book: Power Pivot and Power BI: An Excel User's Guide http://amzn.to/2a8FQSL </video> <video> (SOLUTION) Real World Exercise using Power Pivot and Power Query (Power BI) Description: We present the SOLUTION to our real world exercise. Make sure you first watch https://youtu.be/Smy9X-23pqE and attempt the exercise before watching this video. Download the Excel Exercise Workbook here http://ppvt.pro/1Mlrj0G Watch the the Exercise Intro (including hints to solve the problem) at https://youtu.be/Smy9X-23pqE Read the blog post outlining the Exercise here http://ppvt.pro/1Q7gQIK </video> <video> Disconnected Slicers With DAX Variables And SELECTEDVALUES Description: Video by Reid Havens - Founder of Havens Consulting and contributing author at P3 https://www.havensconsulting.net Today’s topic covers how to create a Disconnected Slicer using DAX Variables and SELECTEDVALUES. We’ve easily written a few dozen articles over the years on ways to use disconnected slicers, and here’s another one! The great thing about DAX is that as it EVOLVES, writing measures and utilizing certain features becomes easier. That’s the goal of this video, it’s not re-inventing the wheel, just refining it. I’ve included below the original DAX Formula I used in the walkthrough. Otherwise, enjoy the video! Value Selection = VAR Selection = SELECTEDVALUE ( 'Value Selection'[Value Selection], "All" ) RETURN SWITCH ( TRUE (), Selection = "Actuals", [Sales Amount], Selection = "Budget", [Budget Amount], Selection = "Forecast", [Forecast Amount], [Sales Amount] ) </video> <video> Modern Excel Awareness Campaign, Pilot Episode Description: Should we continue this series? Upvote if yes, downvote if no. Visit https://powerpivotpro.com/what-is-power-pivot/?src=ytme2 to learn more! </video> <video> Expect More: Get Better Results, Faster Description: Power BI expert Rob Collie explains why nobody should accept long timelines in BI projects. </video> <video> How to Create A Real Time Dataset Description: Video by Reid Havens - Founder of Havens Consulting and contributing author at P3 https://www.havensconsulting.net Learn how to create a real time dataset and provide data input using Microsoft Forms and Microsoft Flow. The custom code used in this video for the Get Response Details step is below. Copy the code between the quotes. " first(triggerBody()?['value'])?['resourceData']['responseId'] " </video> <video> Power BI: How to Combine System & Manual Data Description: This video shows you how you can elegantly and robustly combine system data with manual data. See blog post for more https://www.powerpivotpro.com/2016/11/combine-system-manual-data-power-bi-data-model/ </video> <video> GFITW Power Pivot Training Exercise: Quick Tutorial to learn Power Pivot and Power BI skills Description: Apply the GFITW Pattern (Greatest Formula in the World) to write custom DAX Measures for your Power Pivot and Power BI Model. Download Exercise File: Coming soon Read corresponding blog post: Coming soon </video> <video> Real World Exercise using Power Pivot and Power Query (Power BI) Description: PowerPivotPro.com presents a real world exercise, use this to test your Power Pivot and Power Query (Power BI) skills. Video includes some hints on solving the problem. Download the Excel Exercise Workbook here http://ppvt.pro/1Mlrj0G Watch the Solution at https://youtu.be/Smy9X-23pqE Read the blog post outlining the Exercise here http://ppvt.pro/1Q7gQIK </video> <video> Power BI Measure Dependency View please! Vote for this Idea Description: The Query Dependency View introduced in Power BI is phenomenal. But what we are missing is a Measure Dependency View. Please use link below to vote for the Power BI idea for a Measure Dependency View. Vote at https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16783000-measure-dependency-view-similar-to-the-query-depe </video> <video> Analyze In Excel in Power BI: Most exciting #MSDataSummit Announcement Description: Read more at our blog http://www.powerpivotpro.com/2016/03/victory-at-ms-data-summit-analyze-in-excel-for-power-bi/ </video> <video> Conditional Formatting With Text in Power BI Description: Video by Reid Havens - Founder of Havens Consulting and contributing author at P3 https://www.havensconsulting.net Today’s topic covers how to apply Conditional Formatting using text in Power BI Desktop. Conditional Formatting recently got a feature update, that allows you to apply color formatting rules based on ANY DAX Measure. I recently encountered a business scenario that had me play around with this feature a bit, and I came up with a clever way to use this for a client. </video>

Contacts and Links

Description

www.p3adaptive.com: PowerPivot and Power BI Training, Consulting and Blog

Videos from channel