Power BI Desktop January Feature Summary

Happy new year to everyone! We are kicking off the new year with an update to Power BI Desktop focused on incremental improvements to popular features you are already using, including automatic date hierarchy, data label and axis formatting, and our relative date slicer. The ability to hide pages is another big update that gives you much more flexibility over how users consume your reports.

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

Don’t forget you can now get Power BI Desktop from the Windows Store if you’re on Windows 10!

003c6541 690b 4fef aad3 28981197f13c Power BI Desktop January Feature Summary

Here’s the complete list of January updates:

Reporting

Analytics

Custom Visuals

Data connectivity

Other

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

While creating your reports, you may have needed to hide a page or two perhaps because of in-progress work. You still wanted users to have access to other parts of the report. Hiding pages is also useful when you start using drillthrough or creating your own navigation through bookmarking, and you don’t want you users to access a page through the normal page navigation.

Starting this month, you can now hide any number of pages you want through right clicking the page name and selecting hide.

ce8aa5f5 b857 497f 9867 830e3b5c1728 Power BI Desktop January Feature Summary

While you are editing the report, you’ll still see the pages, but they will look different to indicate they are hidden. You won’t be able to see the pages at all when you move to reading mode.

9f62ffba 6982 496a bfd6 a918edf820f2 Power BI Desktop January Feature Summary

Watch the following video to learn more about hiding pages:

You can now control the background color for data labels in Cartesian and map visuals. This is useful for stylistic changes and readability, especially when you have a situation where the data label is halfway over a data point. You’ll find the option under the Data labels card in the formatting pane. f2ee1553 3e81 4bab 9a57 b8c7f70c7926 Power BI Desktop January Feature Summary

Watch the following video to learn more about data label background colors:

If you have a chart where the axis labels are being cut off, previously your only option would be to increase the size of your chart.

919f3d4c f87e 4739 87df 1bfaa0bf2495 Power BI Desktop January Feature Summary

Of course, that isn’t a great option for many of you as report page space is limited, so this month we are adding a maximum size control for the axis to the formatting pane. This new slider can be used to increase the percentage of the chart used by the axis labels.

356e90dc 2d36 4a44 b583 702bf6b7c2ff Power BI Desktop January Feature Summary

Watch the following video to learn more about axis size control:

Another new axis formatting option we’ve added is the ability to control the inner padding between bars. You can make the inner padding up to 50% of the bar’s width.

01421a97 d97c 4f08 93be 2ca2d43c9e29 Power BI Desktop January Feature Summary

Or all the way down to zero to get a histogram effect.

5276d74e 5c51 4c7c 9ca8 3061f5e81f0b Power BI Desktop January Feature Summary

Watch the following video to learn more about padding control:

For a long time now, we’ve been automatically creating a date hierarchy for you whenever you are using our internal date table. We haven’t been showing that hierarchy in the field list though. Instead we have just created it automatically for you when you drag your data column into a visual. With this latest update you can now see the entire hierarchy in the field list. You’ll need to turn on the preview feature switch under File > Options and Settings > Options > Preview features.

1f187d1a e617 463a 8bc4 945bad4625f6 Power BI Desktop January Feature Summary

This is useful not only because we are being more transparent about automatically generating this hierarchy, but because you can now use individual fields from the hierarchy in your visuals just by dragging or checking the specific level you are interested in. Previously, to do this you would have needed to put the entire hierarchy into the visual and then remove the levels you didn’t want.

Watch the following video to learn more about date hierarchies:

When using the relative date slicer, you may want to start further back in time than today. This is very common whenever your data is complete until a few days later when all sales are finalized. You can now do this with the relative date slicer by setting an anchor date. Once you have an anchor date set, the slicer will be evaluated relative to that specific date. You can set it in the date range options in the formatting pane.

fd76b914 84e9 4fdb b1b1 72618bba2222 Power BI Desktop January Feature Summary

Watch the following video to learn more about anchor dates:

After bringing Q&A to Power BI Desktop in December, we’re continuing to improve the natural language engine itself. You can now ask top-n type questions such as “What are my top 3 products by sales.”

Or “top manufacturer by NSAT”

Both top and bottom work, so try it out on your data!

This quick measure was suggested by Daniil Maslyuk in the quick measures gallery. It calculates the Pearson correlation coefficient between two measures within a certain category – a really common statistical measure of how related two values are.

With the new PowerApps custom visual, you aren’t only able to quickly find insights in your data, you can take action on it as well. PowerApps makes it easy to build automated workflows, and with the new custom visual, that experience is embedded right in your report. If you want to learn more about this visual make sure to read our dedicated blog or checking out the custom visual on AppSource.

You can also watch the following video to learn more about the PowerApps custom visual:

The TreeViz custom visual by AutoCont CZ a.s. lets you display your hierarchical data in a tree like structure. You can expand and collapse each level and decide how many children data points to show before grouping the smaller ones into a single child group.

0d5e9484 fda3 4a74 b956 31590bc039a4 Power BI Desktop January Feature Summary

You can check out this custom visual on AppSource.

Watch the following video to learn more about the TreeViz custom visual:

The Funnel with Source custom visual is perfect to track any metric of interest over various stages along with the source of entry of the data point to the funnel. For example, in the case of sales journey data, this visual displays the channel through which any lead enters the funnel and then the corresponding journey through the various stages of the sales cycle. You can also filter data based on the selection of channel and on the selection of any stage of the sales journey.

3dfe82eb 7999 4298 9d61 cbca841c0e5b Power BI Desktop January Feature Summary

You can find this visual on AppSource.

Watch the following video to learn more about the Funnel with Source custom visual:

Box and whisker charts are most commonly used in statistical analysis to see the spread of your data. They consist of two parts—the main body called the box and the thin vertical lines coming out of the box called whiskers. The first quartile forms the bottom and the third quartile forms the top of the box. The whiskers connect the minimum and the maximum values to the box. In addition to showing median, first and third quartile, and maximum and minimum values, the Box and Whisker chart by MAQ Software is also used to depict mean, standard deviation and quartile deviation.

f2a05aca d24e 4e98 a8f2 1862233c03fe Power BI Desktop January Feature Summary

Make sure to check out this visual on AppSource.

Watch the following video to learn more about the Box ans Whisker chart custom visual:

The Agility Planning Matrix Light by Managility is a matrix visual for planning and budgeting. Some benefits of this matrix visual is the ability to selectively drilldown on specific rows and to display currently applied filters on the visual itself.

f008f92f f8c7 4e0f 946e 254e6bcfdcd9 Power BI Desktop January Feature Summary

Check out this custom visual on AppSource.

Watch the following video to learn more about the Agility Planning Matrix Light custom visual:

The Image Grid custom visual by Fredrik Hedenström is like a word cloud for images. You can display many images and choose for the size to be based on the sort order or the value of a measure. You can also decide to show them in a grid view instead with the top visual to be based on the sort order.

83d0207f cb5d 40ee 85a4 eb0484e83399 Power BI Desktop January Feature Summary

Get this custom visual on AppSource, and watch the following video to learn more about the Image Grid custom visual:

The Gantt Chart by MAQ Software visual is used for scheduling and management of tasks. This visual shows additional details of the task by providing a grid where one can view more data related to the task and can display the hierarchy of data category. Also, it can be sorted based on any data point of the task.

1444afdc fb4e 4c7a bf76 d293ea78f4ce Power BI Desktop January Feature Summary

You can download this custom visual on AppSource.

Watch the following video to learn more about the Image Grid custom visual:

One of the most frequent requests from customers using the Azure SQL Database and Data Warehouse connectors has been being able to leverage Azure Active Directory authentication in order to connect to these Azure services within Power BI.

With this month’s update for Power BI Desktop, we’re introducing a new “Microsoft Account” option within the Credentials dialog for the Azure SQL Database and Data Warehouse connectors, allowing users to authenticate using their AAD accounts.

Note that support for this new authentication type in the Power BI service will come in a few weeks. Please stay tuned to this blog for updates on this capability.

7368d923 c7cf 4084 a111 c87d0090b19c Power BI Desktop January Feature Summary

If you’re using the Windows store app, you can now specify the display language instead of using the default experience of the Windows display language. You can also specify the model language separate from the display language. This is useful if you are working for a global company and there are people from all over the world consuming and creating reports in languages other than the default language the report was created in.

You’ll see these new options under the Regional Settings tab in the Options dialog. Changing the application language will ignore the Windows default display language and switch to the chosen language. Changing the model language will decouple the model language from the application language for any newly created reports. (Note that this won’t affect the model language for existing reports.) Changing either of these settings requires a restart.

9e933c84 d619 4d39 a840 d8b5c7010d15 Power BI Desktop January Feature Summary

That’s all for this month! We hope that you enjoy these updates and continue sending us your feedback. Please don’t forget to vote for other features that you’d like to see in the Power BI Desktop.

b6fbb8f7 ba81 4316 9f6e bec3d29025ee Power BI Desktop January Feature Summary

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI