Power BI Desktop October Feature Summary

This month we are very excited to share one of our most anticipated features from the Microsoft Data Insights Summit: Bookmarking. Combining bookmarking with some of our other recently released features such as drillthrough and what if gives you powerful storytelling capabilities and lets you create highly interactive reports. We also have some more visual improvements and a big update to our quick measures feature this month.

5d7f8edd 60a2 45e6 8cd8 5a7fa35e97b5 Power BI Desktop October Feature Summary

Here’s the complete list of October updates:

Reporting

Analytics

Data connectivity

Other

For a summary of the major updates, you can watch the following video:

We are very excited to announce our preview of bookmarking. This was one of the features we demoed at the Data Insights Summit as a very powerful way to save and share out your insights with others. Bookmarking lets you save interesting states as part of your report. Once you have a list of bookmarks, you can use those in several ways, including a quick way to pick up where you left off in your analysis, for organizing presentations of your report, creating report navigation, and more.
When you add a bookmark to your report, it will include the following:

  • the current page
  • Filters
  • Slicers
  • Sort order
  • Drill location
  • Visibility (more on this later)
  • Any of the “focus” modes

And while we don’t yet bookmark cross highlighting, that is something we definitely plan to implement soon.

Once you turn on the preview feature switch, you can add bookmarks by opening the bookmarks pane, which can be found under the View tab.

3f536867 c0e3 48aa 8821 55758d0c9008 Power BI Desktop October Feature Summary

Set up your report to look how you want, with all the filters properly set, and click the Add button under Bookmarks.

56198c44 9c20 4fd3 a8e7 a58177b70ca7 Power BI Desktop October Feature Summary

This will add a bookmark to pane, which you can rename and go back to whenever you want. You can continue adding as many bookmarks as you want.

30fdc4ac 7cf1 4a11 b9da ee1de2ac6d75 Power BI Desktop October Feature Summary

If you want to use your bookmarks as a story or in a presentation, you can use the View option to enter into a view mode for bookmarks.

6947ed39 de14 4f31 9ee3 8c489c478c85 Power BI Desktop October Feature Summary

When in this mode, there is a title bar for each bookmark that includes the bookmark name and navigation arrows. At this point, you can close the bookmarking pane if you want.

1ec5a1c5 f3ce 4f5a b9eb beeb309ae533 Power BI Desktop October Feature Summary

This mode is a good way to preview your bookmarks in the Power BI Desktop. It’s also a great way to navigate bookmarks in the Power BI service, where you can also enter into full screen mode to hide all the navigation menus.

While bookmarking is in preview, you will need to add your initial bookmarks to your report in the Power BI Desktop. After you publish your reports to the service, you’ll see the bookmarks pane option in the View dropdown and can then edit and view your bookmarks all you want.

6f34f7db 102f 428b 91df b95e790c9621 Power BI Desktop October Feature Summary

Since this feature is in preview, you’ll need to enable it the first time through File>Options and Settings>Options. In the dialog, open the Preview features tab and select Bookmarking.

78a80e63 8857 48fd a2cc 3f4344057b49 Power BI Desktop October Feature Summary

While bookmarking is in preview, we would really appreciate your feedback. What would you like to see added or changed? So please, start playing with the preview and add any and all feedback you have to the comments here and our ideas page!

As part of bookmarking, we also added a new selection pane. This pane lists out all objects on the report page you are currently viewing and allows you to select the visual from here. This is very useful when you are authoring complex reports with many overlapping charts. You can also hide visuals on your report through this pane. By combining this feature with bookmarking, you can create very interesting reports with visuals changing out depending on the current bookmark selection.

You can open the selection pane through the View tab.

9758ea80 d1a7 4da6 8e67 74cbfa751553 Power BI Desktop October Feature Summary

In the selection pane, for each item on the current page, you’ll see either an eye or line icon letting you know if it is visible or not. Clicking on the eye icon will let you toggle the visual between hidden and visible.

649f3cde b234 4fe1 b21f 768a237ab37e Power BI Desktop October Feature Summary

As mentioned earlier, visibility state can also be bookmarked, so it is useful for storytelling purposes. While hidden, slicers will continue to filter the report page, so you can create some pretty interesting reports using this feature.

Another feature we are releasing in coordination with bookmarking is links for shapes and images. Last month, as part of drillthrough, we added the ability to link shapes and images to the previous page to create back buttons. We are extended that linking feature to also allow you to link shapes and images to bookmarks as well. This is a great feature for creating custom navigation in your reports or creating buttons that perform different actions across your report.

You’ll find the option in the formatting pane under the Link card. You can pick either Back or Bookmark as your link type. If you pick bookmark, you’ll have a dropdown to pick one of the bookmarks you currently have in your report.

7259b34e 0ca6 469c 9847 516a37feb37b Power BI Desktop October Feature Summary

Just like the back button, you can activate bookmark buttons by pressing ctrl+click while in editing mode or just clicking in reading mode.

As part of bookmarking, we are also adding a new way to call attention to a specific chart during presentations. You can already use our focus mode to temporarily increase the size of a chart to fill the whole page. If instead, you want to easily call attention to a chart without losing the context of the report, you can spotlight a visual to fade out all the other charts on the page.

6942226f cd22 482c 8f81 d0f20e9bb2ce Power BI Desktop October Feature Summary

Clicking anywhere else on the report will remove the spotlight. You can find this option under the “…” of any chart.

1fee50e0 5d00 4091 9d55 f00ab2a47161 Power BI Desktop October Feature Summary

This spotlight feature can also be included as part of a bookmark.

Learn more about bookmarking, the selection pane, and the related storytelling features in the following video:

Back in June, we released marker controls for line, area, and combo charts, and this month we are extending marker controls to scatter and bubble charts as well. Using the Marker shape option in the Shapes card of the formatting pane, you can change your marker to a circle, square, diamond, or triangle.

9ae3fda1 bf50 45e5 a7d7 6f27f72dcba9 Power BI Desktop October Feature Summary

You can also customize it per series to make your reports more accessible.

869e8e1f cf91 4f02 af33 f03cdf76edf1 Power BI Desktop October Feature Summary

Learn more about scatter markers in the following video:

Last month, we introduced a new sampling algorithm for scatter charts designed with high density data in mind. We didn’t want to stop there, so this month we are also giving you a way to increase the number of data points shown in your scatter chart. Using the new Data volume slider in the General card of the formatting pane, you can set the max data volume to any number between 3,500 and 10,000.

4d51d318 24d8 4f58 b30f a8c64e741226 Power BI Desktop October Feature Summary

Since more data points can mean longer loading time, if you do choose to publish reports with limits at the higher end of the scale, make sure to test out your reports across the web and mobile as well make sure performance matches your users’ expectations.

Learn more about increasing your scatter chart’s data volume in the following video:

Now you can use quick measures for report that are using live connection mode against SQL Server Analysis Services models. You can turn on the preview feature switch and start using them right away in your models. One thing to be aware of is since different quick measures require support for different DAX functions and operators, some quick measures won’t be available on certain AS server versions.

We also are extending quick measure support to work with your custom date tables. Previously, the time intelligent quick measures (period-to-date, period-over-period, rolling average) could only be used with the Power BI-provided hierarchies. Now, if your model has a custom Date table (for example, the DimDate table in the AdventureWorks model), you can use the primary date column in that table for time intelligent quick measures. You’ll need to make sure the person who build the model has marked it as a Date table.

We also have yet another quick measure to share with you: totals from new categories! You’ll find this new quick measure under the Filters category.

salesFromNewCustomers Power BI Desktop October Feature Summary

This quick measure lets you find things like the sales data for first time customers or the number of first time helpdesk callers.

31fbc3fe 3b18 4f15 863d be36ba8c6381 Power BI Desktop October Feature Summary

Thanks to Marco Russo for submitting this in the Quick Measures Gallery. Be sure to try this new quick measure out and let us know what measures you’d like added next!

See the new quick measure in action in the following video:

If you have cell-level formatting set up in your on-premises SQL Server Analysis Services models, this will now be respected in your Power BI reports! You’ll see the formatting for your values in our table, matrix, and single value card visuals, with no additional setup required. Here’s an example from the AdventureWorks cube:

cfaa08d1 aa7d 4b1e b426 698f44477924 Power BI Desktop October Feature Summary

With this month’s update, we’re adding a new data connector to Power BI Desktop for Vertica. The Vertica Analytics platform is designed for use in data warehouses and other big data workloads where speed, scalability, simplicity, and openness are crucial to the success of analytics. Vertica relies on a tested, reliable distributed architecture and columnar compression to deliver blazingly fast speed.

The new Vertica connector allows you to build reports by importing or creating a DirectQuery connection to your databases in the Vertica Analytics Platform.

The new Vertica connector is available as a beta connector and can be found under the “Other” category within the Get Data dialog.

35ac6567 03af 4fec 8d3e 8e8ed8ff21d2 Power BI Desktop October Feature Summary

When selecting this connector, you will be prompted to specify your Vertica server/database details and will be able to specify which Data Connectivity mode to use.

cf1932d0 7a21 4f4f a238 f8362741695d Power BI Desktop October Feature Summary

The first time you connect, you will be asked to specify credentials for Vertica.

99508d51 4ec1 4063 9c11 28ecddd11f25 Power BI Desktop October Feature Summary

Once the connection has been established with your credentials, you’ll be able to browse and select one or multiple tables within the Navigator dialog and then decide to load or edit your data.

223d725d af50 4ed2 9d3d f38dffc98acf Power BI Desktop October Feature Summary

One of the most requested features for the SAP BW connector has been the ability to import additional member properties, besides Medium Name. With this month’s release of Power BI Desktop, we’re making these properties available in the SAP BW connector so that you can select them within the Navigator dialog.

You can select one or multiple properties for each selected object, which will be represented as new columns in the output results of your queries.3756dd75 3350 46c2 9ca1 1795894b40d6 Power BI Desktop October Feature Summary

In case you missed the announcement at Ignite, we are very excited to announce that you can now get Power BI Desktop from the Windows Store. Until now, you could get Power BI Desktop by downloading it manually (from within the Power BI service, or from our download location) and install it directly – often referred to as an MSI installation. With the new option of installing it from the Windows Store, you can take advantage of:

  • Automatic monthly updates installed in the background as soon as it’s available
  • No longer needing admin privileges to install
  • Smaller download size since the Windows Store makes sure that only the components that have changed in each update are downloaded to your machine
  • Easier IT deployments for everyone in your organization, including making Power BI Desktop available through the Microsoft Store for Business
  • Automatic language detection each time Power BI Desktop is launched

You can learn more about this feature and our other announcements at Ignite in our dedicated blog post.

Learn more about Power BI Desktop in the Windows Store in the following video:

We want to make it even easier for new users to find content that will help the learn Power BI and current users get access to community sites, so this month we are adding a Help tab. This tab is all about giving you quick and easy access to all these resources.

b4b59145 def8 407b 89eb 26f96b90fdb6 Power BI Desktop October Feature Summary

We also know how important it is when a user is new to get access to these resources, so we have integrated our newsletter form into the first experience. Starting this month, new users will see a form to fill out before they can start using Power BI Desktop the first time. Once this form is filled out, we can provide helpful newsletters with getting started content and latest announcements.

cc45f23f 89f7 4faf 81f1 ce24ed3bbd4c Power BI Desktop October Feature Summary

That’s all for this month! We hope that you enjoy this new update and continue sending us valuable feedback about our product. Please don’t forget to vote for other features that you would like to see in the Power BI Desktop in the future.

5d7f8edd 60a2 45e6 8cd8 5a7fa35e97b5 Power BI Desktop October Feature Summary

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI