Power BI Desktop June 2019 Feature Summary

new features

Following Microsoft’s big announcements, we, of course, also have a big update for our June update for Power BI Desktop. These are a lot of new features and updates to the existing features this month. Some of the highlights include a top UserVoice ask, visual level filters for slicers and more formatting options that can be changed based on expressions. We also modernized our side panes and added support in Power BI Desktop for shared and certified datasets, a much-anticipated capability that will help our customers establish single sources of truth on their organizations and to continue driving a data culture based on collaboration and sharing.

Here’s the complete list of June updates:

Reporting 

  • Updated pane design
  • Visual level filters for slicers
  • Sorting for the performance analyzer pane
  • Conditional formatting updates for formatting options
    • Visual background and title colours
    • Card colours
    • Gauge fill
  • Visual header tooltips
  • Table & matrix total label customization
  • Sync slicer support for Hierarchy slicer
  • Consistent font sizes across visuals

Analytics 

  • Key influencers visual updates (preview)
    • Key influencers with Live Connect to Power BI datasets
    • Key influencers accessibility
    • Support for Cloud RLS
  • Manage aggregations dialog accessibility

Modeling 

  • New DAX comparison operator: ==

Visualization

  • Personalized visualizations pane (preview)
  • SCADAvis.io Synoptic Visual
  • PAFnow Process Mining
  • DualCard

Data connectivity 

  • Connect to shared and certified datasets
  • Common Data Service connector is now generally available
  • Azure Data Explorer connector is now generally available
  • Enhancements to the Cosmos DB connector
  • Entersoft

Data preparation

  • Improvements to M Intellisense

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

Reporting

Update pane design

We’ve refreshed much of our interface. We’ve updated all our panes, the footer, and view switcher to be a lighter colour, updates spacing, and new icons. Our new look is much more modern and is the first step to refreshing the entire interface. Watch the following video to see the new panes in action:

Visual level filters for slicers

This month you can now finally add a visual level filter to slicers. This has been a popular idea on ideas.powerbi.com. It works just like any other visual filter. It will just filter the slicer itself and no other visuals. This can be useful for filtering out blanks or if you want to use measure filters.

The filter that the slicer applies to other visuals don’t change-it’s still just the selection made of the value in the slicer. Watch the following video to learn more about visual level filters on slicers:

Sorting for the performance analyzer pane

We have a small update to our new performance analyzer pane this month as well! You can change the sort direction and pick between:

  • Total time spent
  • Order the actions occurred
  • Time spent on the DAX query
  • Time spent querying the source (for Direct Query)
  • Time spent displaying the visual

Watch the following video to learn more about sorting on the performance analyzer:

Conditional formatting updates for formatting options

Visual background and title colours

We are extending our conditional formatting option to formatting features this month. First, we’ve added support for conditionally formatting the background of the visuals and both the visual titles font colour and background colour.

Card colours

For the card visual you can now also conditionally format the data label and category label.

Gauge fill

Lastly, you can conditionally format the fill colour of the gauge. With all these updates, you now have a lot more expressive power when formatting your visuals. In addition, we have plans to add more expression-bound formatting options in the coming updates as well.

Watch the following video to learn more about the conditional formatting updates:

Visual header tooltips

We’ve seen users add helpful information for their end users to reports, such as hints on how to interact with the report or descriptions of the fields used in the visual. Setting that up though used to take a fair amount of work, so we’ve now added a way to add a tooltip directly to the visual’s header.

This option is off by default, but you can turn it on through the visual header tooltip icon toggle in the visual header card of the formatting pane. This is the one toggle within the card that is affected if the icon shows in edit mode, as well as reading mode.

Once the toggle is on, you’ll see a question mark and you’ll see a new formatting card in the pane call visual header tooltip. In this card, you can add the text to show in the tooltip and the formatting of the tooltip. Alternatively, you can pick a report page tooltip instead if you need more customization.

Once you’ve added tooltip text or selected a report page tooltip, you’ll see it when hovering over the question mark icon. Watch the following video to learn more about the visual header tooltips:

Table & Matrix total label customization

There was a lot of buzz in our community around a simple ask for allowing the total label for table and matrix to be customized. An engineer on our team saw the request and decided to squeeze the feature in on his free time to help out our customers. So now, you have the option to change the label under the subtotals card for both columns and rows. You can also customize the label for each subtotal field when the stepped layout is off. Watch the following video to learn more about customizing the table and matrix total labels:

Sync slicer support for hierarchy slicer

The hierarchy slicer, one of the most used marketplace visuals, allows users to display a hierarchy within their slicer for optimized navigation. This is a very powerful visual, but until recently, it had a limitation where it couldn’t work with our sync slicer feature. With this month’s update, we’ve improved our sync slicer feature to support hierarchy slicers now. This support could also extend to other marketplace visuals if those visuals add support for the right capabilities. Some things to be aware of are that you can’t sync two hierarchy slicers that have different columns from your model, and if you remove columns from one slicer, it will not remove it from the other synced slicers. Watch the following video to learn more about sync slicer support for hierarchy slicers:

 

Consistent font sizes across visuals

If you’ve been building Power BI reports for a while, you may have noticed that when you set the font size to a specific size, such as “8”, the size might look different, depending on where you’ve been setting it. The reason for this is that different places were either using pixels or points to represent the font size, and 8 pixels is a different size compared to 8 points. With this month, we’ve updated all the formatting options within our visuals to always use points. There are still a few places using pixels, such as textbox and we will work to update those places as well in the coming months.

Analytics

Key Influencers visual updates (preview)

Key Influencers with Live Connect to Power BI datasets

We’ve now added support for the Key Influencers preview visual when you are live connected to Power BI datasets in the Power BI service. When using a report that is live connected to a Power BI dataset, the visual should now be enabled and work just like it does for imported models.

Key Influencer accessibility

We’ve also added support for accessibility feature this month. You can now navigate the visual using just a keyboard, use a screen reader to read off the information from the visual, and turn on high contrast mode and see the visual updated appropriately.

Some specific keyboard shortcuts include:

  • Ctrl + right arrow to move focus inside the visual
  • Enter/space to select whichever bubble is in focus
  • When a bubble is selected, the focus moves to the drill visual, and Esc will close it

Support for CLoud RLS

When viewing a report in different RLS roles, you can now use the Key Influencers visual and see the types of insights your consumes will get when viewing the report with the proper security applied. Watch the following video to learn more about the Key Influencers visual updates:

Manage aggregations dialog accessibility (preview)

The manage aggregations dialog, which is part of our aggregations’ preview, is now accessible. You can use a keyboard to navigate around the dialog along with a screen reader to read off information about what’s in focus. Hih contrast modes are also supported. Watch the following video to learn more about the aggregations’ dialog updates:

Modeling

New DAX comparison operator: ==

Our DAX update for the month is the addition of a new comparison operator: ==. This operator is similar to the existing = operator except that it performs a strict comparison to BLANK values. In DAX, 0 = BLANK() returns true so a filter like [Column] = 0 or [Column] = BLANK() will return true for both 0 and BLANK(). We’ve introduced this new == operator to make it easier to differentiate between 0 and BLANK(). [Column] == 0 will return true only when the column value is 0 and [Column] == BLANK() is equivalent to ISBLANK([Column]). Watch the following video to learn more about the new DAX comparison operator:

Visualization

Personalized visualization pane (preview)

With this months update, we’ve tweaked the visualization section of the pane to allow for personalization. With the personalized visualization pane preview turned on, you can now pin any marketplace visual to your pane and have it show up automatically for you every time you open any report. Any visuals you add to your report now show up below a dashed line.  If you plan on using any of these visuals across multiple reports, you can right-click on the visual to pin it to the pane.

Once the visual has been pinned, it moves up to live with the other built-in visuals.  This visual is now also tied to your signed in account so any new reports you built will automatically have this visual included, assuming you are signed in. This makes it very easy to standardize on a particular visual without needing to add it to every single report.

While this feature is in preview, you’ll only see your pinned visuals in Power BI Desktop. You’ll still have the older experience in the Power BI service. Additionally, you must be signed in for this feature to be available. Watch the following video to learn more about the personalized visualizations pane:

SCADAvis,io Synoptic Visual

The SCADAvis.io synoptic visual by DSC_Systems is a powerful visual that brings SCADA-like capabilities to Power BI. You can use the SCADAvis.io Synoptic Editor from the Microsoft Store to create vector graphics and tag data-linked animations directly in the SVG file. You can then upload the SVG to the visual. You can use the following animations:

  • Size
  • Rotation
  • Position
  • Colour
  • Transparency
  • Text
  • Tooltips
  • Scripts
  • Vega specifications

Up to 35 animated objects per panel are free, and you can use in-app purchases to add more.  Watch the following video to learn more about the SCADAvis.io synoptic visual:

PAFnow Process Mining

The PAFnow Process Mining visual by Process Analytics Factory GmbH is a powerful flow chart visual to analyze your business processes based on event data. This visual lets you explore process variants, identify bottlenecks, discover root-causes, and much more.

While this is an in-app purchase visual, you can test drive the PAFnow Process Mining visual to accelerate your projects. You can find the visual on AppSource. Watch the following video to learn more about the PAFnow Process Mining visual:

DualCard

The DualCard visual by Inservit is great for comparing two measures. Some key features of this visual are:

  • Compare two measures, the first called data and the second called comparison measure
  • Formatting options for data and comparison measure
  • Display blank measure as a static value
  • Support for large font sizes
  • Conditional formatting for fill, background, labels, & categories
  • Card orientated & fill options

You can try out this visual by downloading it from the AppSource. Watch the following video to learn more about the DualCard visual:

Data connectivity

Connect to shared and certified datasets

As you work to build a data culture where organizations leverage insights every day at all levels, a key part of that is ensuring availability of standard, authoritative datasets that represent a single source of truth. This allows users to make decisions on trusted data and provides visibility and control of governance. To enable this with Power BI, we are previewing shared and certified datasets.

With shared datasets in Power BI, you are allowing a single data set to be used by multiple reports, even across workspaces. You can either build new reports based on datasets in different workspaces or you can copy existing reports across workspaces. With certified datasets, organizations now have a mechanism to distinguish the most values and trusted datasets. Certified datasets show up prominently so users can easily find these authoritative data sources.

In Power BI Desktop specifically, you can connect to shared and certified datasets directly. We have a new experience when connecting to Power BI datasets where you can sort on the name, endorsement, owner, workspace or last refresh time. You can also search in the dialog too.

As a part of this work, we are also making a licensing change. Going forward, free users will no longer be able to connect to datasets that are not in Premium. If you are using one of the national clouds, this feature will start working a few days from now. Watch the following video to earn more about connecting to shared and certified datasets:

Common Data Service connector is now generally available

We’re very glad to announce the general availability of the Common Data Service connector in this months release. The common Data Service is a foundational component of the Microsoft Power Platform, enabling you to securely store and manage data that is used by business applications. It’s also seamlessly integrated with the rest of the Power Platform so that you can very easily build Power Apps Flows and Power BI reports on top of your common Data Service data. You can find the common Data Service connector under the “Online Services” category within Get Data dialog.

Azure Data Explorer connector is now generally available

With this month’s release, the Azure Data Explorer connector is now generally available. With this update, we’ve also improved query generation and added additional M function support (for example, Number.BitwiseXor, Number.Atan2, List.StandarDeviation, Table.RowCount and more).

All of this results in better performance and resource utilization. In addition, you can now provide set statements as part of the connection creation.

Enhancements to the Cosmos DB connector

This month we’re also making a lot of enhancements to the Cosmos DB connector, including:

  • Query folding support – The connector now folds m expressions into Cosmos DB queries. Operations like projections, comparisons (arithmetic & logical), text operators (StartsWith, EndsWith & Contains) are all pushed down to Cosmos DB. This improves performance and resource utilization on clients by making effective use of Cosmos DB server-side resources.
  • Resource token support – Instead of using the Cosmos DB master key which gives access to all the collections in the account, you can restrict access to a particular collection by using the resource token for that specific collection.
  • General performance and reliability improvements – Including improved handling Cosmos DB throttle.

Entersoft

Entersoft Business Suite is a comprehensive and integrated business software suite for ERP, CRM, Retail, Mobile, E-commerce and Business Intelligence applications. Entersoft BusinessSuite supports multi-company and multi-dimensional organizations in a single database. Through the Entersoft Power BI connector, in a few simple steps, data can be fetched into Microsoft Power BI either from the pre-packaged ready-to-us Entersoft Business Data Sets that span across all entities such as customers, offers, payable & receivable accounts, sales, leads, opportunities, tasks, warehouse operations, field sales, etc. or from custom made datasets and reports that can be added into the Entersoft Power BI Data Sets.

Data preparation

Improvements to M Intellisense

Based on recent feedback, we’re making additional improvements to the M Intellisense capabilities that we release a few months ago.

  • Parameter hint support in formula bar – This previously only worked in the Advanced Editor and Add Custom Column dialogs. This month, we’re adding support for parameter hints in the formula bar.
  • Hover support – Hovering your mouse cursor over identifiers (such as functions and query step names) will display its definition. This works on all M Intellisense surfaces (Advanced Editor, Custom Column and formula bar)

That’s all from for this month from Power BI. These are exciting new features that will take your reporting and insight into your business to the next level. If you would like to chat with a consultant about Power BI you can contact us on  info@allonline365.com or call us on  +27 (21) 205 3650  .

www.allonline365.com 

Resource Credit | Power BI

 

Allonline365 Newsletter

* indicates required
Business Software News
Call Now Button