Power BI Desktop August Feature Summary

This month we are very excited to release our What if feature, which we previewed in the Data Insights Summit keynote back in June. We’ve also added even more features for our table and matrix visual, including a formatting option to show values on rows of your matrix. We also have several new analytics features, such as symmetry shading and ratio lines for scatter charts.

5d7f8edd 60a2 45e6 8cd8 5a7fa35e97b5 Power BI Desktop August Feature Summary And don’t forget to also check the Power BI service and mobile July feature summary.

Here’s the complete list of August updates:

Reporting

Analytics

Data connectivity

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

Following on our announcement last month that the new table and matrix visuals are generally available, we’ve added even more new features to these visuals.

The first is the ability to show the values as row headers instead of column headers.

If you have multiple values in the Values field well bucket, they will by default show as column headers in the matrix.

83431cd5 a830 4bd0 83cf 6a0a2974671a Power BI Desktop August Feature Summary

If you would prefer for them to show as row headers instead, we now have a formatting option, Show on rows, that when switched to On will show each of the values on the rows of your matrix.

abb5124c f1db 4f19 9a25 d09f59a350ae Power BI Desktop August Feature Summary

Find more details about showing values on rows in the following video:

You can now apply conditional formatting to your column’s font color instead of the background of cells.

You can reach this new option either from the value’s menu….

fa3e042c d430 4d38 94a4 0dd070503d04 Power BI Desktop August Feature Summary

Or in the formatting pane…

66ab3e47 1364 4013 b083 a191bfc9ecd9 Power BI Desktop August Feature Summary

Once you select Font color scales, you’ll see a dialog similar to the background color scales that lets you customize what colors you use and the range.

45633206 8a42 452c a328 e274cbc07582 Power BI Desktop August Feature Summary

Once you have the style you want and close the dialog, you’ll see the formatting applied to that value’s text.

7822e0dd 2d0a 415e 87cf e186196c9585 Power BI Desktop August Feature Summary

Find more details about color scales on font colors in the following video:

Another great new feature for the matrix visual is the ability to customize whether subtotals are displayed for each level of the matrix hierarchy for both rows and columns. You’ll find this option in the Subtotals card of the formatting pane.

bda6028a d927 44ff 810f 70ecb75a79c4 Power BI Desktop August Feature Summary

Another new subtotal customization is an option to move the row subtotals to the bottom of the group instead of the top. You can also find the Row subtotal position option in the Subtotals card of the formatting pane.

89273d6f b3bf 44c6 964c ba1e94e44eb0 Power BI Desktop August Feature Summary

Find more details about customizing subtotals in the following video:

This month we are adding even more formatting options for your line charts. You can now set the style for line charts to dotted and dashed in addition to the standard solid line style. This feature is great not only for styling your charts, but also for accessibility, as you now have even more options to format each line differently without having to rely on color.

dec30f89 dbb0 4e04 8933 58dd0b28baab Power BI Desktop August Feature Summary

This month we are also letting you customize how your line chart’s legend is styled. You can pick between markers only, the line style only or a combination of line and marker. This lets you pick the legend option that best communicates which category pairs with which line.

9d6bb229 7fbe 4b8f b932 e9d2d22b904b Power BI Desktop August Feature Summary

If you pick the marker only option for the legend, you’ll also be able to pick whether the legend colors match the line or the marker. You can also choose if a line or circle is used for the default icon when no marker is applied to a specific line.

fcb92e76 8f6a 4f65 9887 828de7b41049 Power BI Desktop August Feature Summary

Find more details about line styles in the following video:

We’ve made changes to how we are rendering the scatter chart. Now you should see up to a 30% performance improvement to your scatter chart’s load time. If you’re showing a large number of data points in your scatter charts, this should result in a significant performance improvement.

This month we have four new custom visuals we want to share with you.

Dot Plot by MAQ Software

The dot plot by MAQ Software visual plots individual data points on a simple scale, and is often considered one of the most useful chart types by many data visualization experts, including Steven Few.

This visual is useful in many scenarios where you want to see the distributions of individual values, such as student scores, customer revenues, employee salaries, city population, movie ratings, or sport player scores. This custom visual also allows you to view your data across several different categories, enabling effective comparisons.

As an example, the dot plot below shows annual sales data by state (each dot) and its region (the x-axis). The legend is used to quickly tell which states perform better (blue) and which ones need attention (red), and the size of the dot shows profit margin.

bf32965c a0d4 40ab ae32 b5bdcf73a2bc Power BI Desktop August Feature Summary

You can also have multiple categories on the x-axis, allowing you to explore the data split by an additional category. In our example, we also want to explore the seasonality of the data, we added the quarter field to the chart.

03456db1 a67f 4aa5 8e49 2b4ac0631334 Power BI Desktop August Feature Summary

This visual also has tons of features in the formatting pane, including chart orientations, label controls, background shading, gridlines thickness and colors, and bubble colors and thickness.

f797c39e c6e1 4f33 a53a 1ace4ca5db2d Power BI Desktop August Feature Summary

Test out this visual by downloading it from the custom visual store.

Find more details about the Dot Plot by MAQ Software in the following video:

Power KPI

The Power KPI visual is useful for presenting your key performance indicators (KPIs). The visual can include:

  • Title and subtitle
  • The KPI status and date
  • A line chart with the KPI trend, forecast line, and other comparison lines

This visual has tons of formatting options such as options for KPI symbols and control for the line chart in the KPI similar to the standard line chart visual in Power BI.

b7c7e78c ab5a 4588 a6f1 2445b29530bc Power BI Desktop August Feature Summary

Try out this visual by downloading it from the custom visual store.

Find more details about the Power KPI custom visual in the following video:

Funnel plot

The funnel plot is an R custom visual that helps you not get distracted by statistical noise. It helps you compare samples and find true outliers among the measurements with varying precision.

65dd385f e17f 4db0 bd8b 2b3f1fbd3806 Power BI Desktop August Feature Summary

To use this visual you start by defining two required fields to be analyzed in the chart, such as occurrences and population. The y-axis can show either a percentage or ratio, and a “funnel” is formed by confidence limits and shows the amount of expected variation. The dots outside the funnel are outliers.

Download this visual from the custom visual store to test it out.

Find more details about the funnel plot in the following video:

Beyondsoft Calendar

The Beyondsoft Calendar visual gives you a heatmap-like view of a value across all the days of a month. You can give the visual a date field and the numerical value you want to visual. From there, you can format the colors used and the layout of the calendar. This is very helpful if you have a measure you are tracking across time.

7ad09999 e363 4523 ad92 227235f3c5bf Power BI Desktop August Feature Summary

Check it out in the custom visual store!

Find more details about the Beyondsoft Calendar custom visual in the following video:

We’ve heard from many of you that you’d like to interact with controls on a report to change a variable in your data. An example of one of these scenarios is in a mortgage calculator report, you’d want to change the % rate, borrowed amount, and term to see projected repayments.

To allow you to create these type of reports, we’ve added a new section to the Modeling tab, called What If. Using this new feature, you can create new parameters that you can use in your DAX expressions.

1275cce6 334b 4ebc a229 fb30b636bc02 Power BI Desktop August Feature Summary

When you select to add a New Parameter, you’ll open a dialog where you fill in all the details about the parameter:

  • Name
  • Data type
  • Minimum and maximum value
  • Increment to increase by
  • Default value

parameterDialog Power BI Desktop August Feature Summary

Once you finish filling out the dialog and click OK, we will use that information to create a new table with two fields. The first is a column with all the possible values for the parameter. It’s very useful for putting in a slider for viewers to use when using the report. The second field is a measure that will also be equal to the currently selected value of the parameter column. This is what you’ll want to reference in your other calculations.

parameterTable Power BI Desktop August Feature Summary

Once you use the parameter measure in your calculations, you can use those measures in your charts and have them update as you move the slider with your parameter column.

whatIf Power BI Desktop August Feature Summary

Find more details about what if parameters in the following video:

For scatter charts, we’ve added two new options in the Analytics pane: symmetry shading and ratio line.

Symmetry shading

Symmetry shading is a new analytics feature that allows you to easily see which points have a higher value of the x-axis measure compared to the y-axis measure and vice versa. When you turn symmetry shading on in the Analytics pane, we’ll shade the background of your scatter chart symmetrically based on your current axis bounds. This is a very quick way to identify which measure a data point favors, especially when you have a different axis range for your x- and y-axis.

cc9673a5 ccbf 47b0 995e d5bc1f55eb69 Power BI Desktop August Feature Summary

Ratio line

The ratio line feature plots the ratio of the subtotals of x-axis and y-axis measures to let you see overall which measure has a higher value. When comparing data points to this ratio line, it allows you to see how much any given point deviates from overall. Points to the left of the ratio line favor the y-axis measure more than overall, and points to the right favor the x-axis more than overall.

Using these two features together you can find some very interesting insights, such as in the example below. You can see from the shading that A. Datum in general has a higher net satisfaction score than its likelihood to be purchased again. However, when you compare it to the ratio line, you can see that it doesn’t favor NSAT compared to overall.

f5f5f10c 98c3 492a 8798 e7270ca27cb6 Power BI Desktop August Feature Summary

Find more details about the scatter chart analytics features in the following video:

We’ve added another quick measure this month, weighted average per category. This measure calculates a weighted average of the base value for each category. We will multiply the value by the weight for each category, sum the total, and then divide by the sum of the total of the weight. You’ll find it under the aggregate by category section in the quick measures dialog.

weightedAverageQuickCalc Power BI Desktop August Feature Summary

Find more details about the weighted average quick measure in the following video:

We are very excited to announce that our Power BI service connector is now generally available. Now everyone can start using this feature to connect to any of their datasets in the Power BI service. This makes it very easy to create a model once and reuse it in many reports.

94736bc5 4aaa 40b1 a64f 2044f0f7aeaa Power BI Desktop August Feature Summary

Along with making the connector generally available, we have two new improvements this month as well.

First, in addition to giving you a status indication in the bottom right section of Power BI Desktop, we also let you know the dataset and workspace you are currently connected to.

b79973a6 4f12 4b21 b59b 8befe4cc9039 Power BI Desktop August Feature Summary

Second, we now let you update what dataset you are connecting to. This is a very useful feature if you want to use a staging or development environment when building your reports and then switch it to point to the production dataset right before publishing and sharing. You’ll be able to switch out what dataset you are connecting to using the Data source settings option under Edit Queries in the Home ribbon.

550db7d7 ca91 4f30 b536 5a8530b9f4a4 Power BI Desktop August Feature Summary

We’ve released a new beta connector this month for Google BigQuery. This connector allows you to easily create reports on top of Google BigQuery databases, either by using Import or DirectQuery mode.

The new Google BigQuery connector can be found under the Database category within the Get Data dialog.

5be76b5c 4fce 4c4b 841e 90062d0054f8 Power BI Desktop August Feature Summary

With this connector, you can select data from the bigquery-public-data project and any other project associated with your Google BigQuery account.

b72cb3a9 5f0e 4201 be48 f950625ceace Power BI Desktop August 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 August Feature Summary

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI