Sign-up now and get instant access
Leave a comment
Beginner to advanced classes taught by Microsoft MVPs and Authors.
In-depth boot camps take you from a novice to mastery in less than a week.
Season Learning Pass
Get access to our very best training offerings for successful up-skilling.
Customized training to master new skills and grow your business.
Quick references for when you need a little guidance.
Summaries developed in conjunction with our Learn with the Nerds sessions.
Digital goodies - code samples, student files, and other must have files.
Stay up-to-date on all things Power BI, Power Apps, Microsoft 365 and Azure.
Earn money by driving sales through the Pragmatic Works' Training Affiliate Program.
It's time to address your client's training needs.
Learn how to get into IT with free training and mentorship.
Discover the faces behind our success: Meet our dedicated team
How can we help? Connect with Our Team Today!
Find all the information you’re looking for. We’re happy to help.
Welcome to the latest Power BI Monthly Digest, where Pragmatic Works president Devin Knight and trainer Matt Peterson look at the latest additions to the ever-evolving Power BI platform. September brings a handful of small but impactful features, plus a new visual.
> The Smart Narrative Visual is a preview feature consisting of a large text box, like a memo pad, that analyzes all the visuals on a report page and displays them in text format. It’s similar to quick insights when publishing out to the service, but instead of providing extra visuals, it outputs the data so it can be digested through text. Text can be added, deleted, and formatted, and specific end values can be coded in. Apart from making a Smart Narrative for an entire page, you can make one for an individual visual. Check out the video for a breakdown of exactly how this visual and its features work.
> Q&A now performs mathematical operations, eliminating the need for a separate measure (or a calculator). For example, you can ask Q&A “France profit margin + United States profit margin” and the results bring up a basic mathematical calculation. The feature can add, subtract, multiply, divide, and do order of operations with parenthesis.
> Last month, the usability feature Data Point Rectangle was added for when you have a multi-selection on a chart, and you want to see all the filters be affected with cross-filtering. As opposed to selecting each individual data point, the Data Point Rectangle grabs all the points, similar to the lasso preview feature. This month, the feature was updated so it works on almost every visual out there.
> Image Layer Order cements visuals in place. This keeps you from losing visuals within multiple layers, but keep in mind the final result will only show up in read view.
> When publishing, you can now search for a specific workspace, eliminating the need to scroll through dozens of options. Prior to this addition, you could do this in the service, but not on desktop.
> Totals can be viewed for stacked visuals, combining all the values in features such as charts and displaying the sum at the top, which can be formatted as one pleases.
> There are more options for mobile view when designing on desktop, including bookmarks, guidelines, and the snap-to-grid, making it easier to design a report that displays properly on mobile.
> Changes to Enhanced Dataset Metadata that have been in process over the last several months are now available. They provide the ability to tap into external pools such as Tabular Editor or Dax Studio.
> There were performance improvements on aggregations, making currency columns work at a faster rate.
> A few new data connectors were released, including Azure Data Bricks data connector and Maria DP database connector.
Watch the video to see walkthroughs and step-by-steps of each new feature, plus hear insights from Devin and Matt. Let us know what you think about the latest additions in the comments below.
Reach out to firstname.lastname@example.org to learn about Power BI or check out our On-Demand Learning, which includes over 18 courses on Power BI and over 60 courses on other data analytics topics from Azure to SQL Server. Click here to start your 7-day free trial now.
ABOUT THE AUTHOR
• Microsoft MVP • Leads all training programs for Pragmatic Works • Business Intelligence consultant with work experience building SQL Server data warehouses • Experience building SharePoint BI solutions with Excel Services, PowerPivot, PerformancePoint, Reporting Services and Power View • Work daily with entire BI stack: SSIS, SSAS, SSRS for SQL Server • Speaking history at multiple SQL Saturdays, SQL Rally and PASS Summit • Planned and implemented Both proof of concepts and full production ready BI solutions. • Professional Association for SQL Server (PASS) member • Leads the Jacksonville SQL Server User Group • Author of 6 SQL Server books
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.