Considering we are Power BI consultants, it only makes sense that we share the latest news and information that comes with every monthly Power BI update. Every month, Microsoft Power BI comes with new updates to the internal applications and processes, and in this month’s case, there is a new modern ribbon that aligns Power BI with other Microsoft Office programs. There is also a brand new visual, which many of us we eagerly waiting for.
Whether you use Power BI in your job as a developer or analyst, the feature summary as well as this blog will hopefully be of great use to you as Power BI continues to be one of the most versatile business intelligence programs on the market today.
The November 2019 update includes upgrades in:
- Data Connectivity
- Data Preparation
- Template Apps
Decomposition Tree Visual (Preview)
The Decomposition Tree visual is a feature that has been frequently requested from Power BI users. A Decomposition Tree can be used to perform a root-cause analysis. This involves viewing individual categories in a group, and analysing how they individually contribute to the whole process. Using the visual, you can isolate and break down a group to see its individual categories, and how they rank according to a measure (e.g. by total sales). Using the Decomposition Tree pane, you can decide which field you want to analyse, and in what order.
You can read more about the Decomposition Tree here.
Button Updates (Conditional Formatting)
The conditional formatting update for this month all relate to buttons. You can set formatting for button text, text font colour, outline colour, fill colour, icon line colour and button tooltip properties.
ArcGIS Maps for Power BI (Update)
The ArcGIS Maps visual now contains support for connecting to ArcGIS Enterprise servers (using built-in authentication). As an ArcGIS Subscriber, you can now geocode up to 10,000 points (as well as full Esri Technical Support for ArcGIS Maps), and 3,500 as a free user.
New xViz Visuals
The Advanced Gauge visual has now come to the xViz visual suite, which currently contains nine visuals in the package (both available with free and pro features). The Advanced Gauge visual allows you to compare your target values with your actual values, which has plenty of options for customising and configuring.
In addition, the Hierarchical Filter visual has arrived, which is a slicer visual that supports advanced formatting, search, displacement of metrics and, as the name suggests, hierarchies.
ZoomCharts Drill-Down Waterfall Visual
This new addition to the ZoomCharts custom visuals library comes with usual ZoomCharts features, such as interactive drill-down, smooth animations and plenty of customisation options. This visual is particularly useful for visualising increases and decreases, and totals.
Financial Reporting Matrix
The Financial Reporting Matrix visual is aimed at easily building financial reports, with a matrix-like visual with many formatting options typical in a report.
This visual allows you to see indicators for each category of a field you put into a visual, such as the legend of a visual. These indicators can be used as a method of filtering the report, complete with formatting options.
Using this visual, you can see hierarchical data in a tree-like format. You need to give the tree a Parent ID and a Child ID and a structure will be mapped out accordingly, and formatted as well.
Did you know?
You can combine all measures into one table in Power BI.
When lots of measures are created, they can eventually become more difficult to locate. You can organise all measures in one table which can be dedicated purely to them. When creating a new table, you don’t have to even enter column values, all you need to do is create one measure and delete the empty column. All measures can be created in the same table now.
LinkedIn Sales Navigator Connector
This sales navigator allows you to access the LinkedIn member network, to help sales professionals network and build relationships with prospective customers and connections. This information can be used in Power BI using this new connector.
Other connectors include: Vena, SiteImprove, Product Insights and Web By Example
Edit SAP Variables Experience (Generally Available)
The August update included the preview of Edit SAP Variables Experience, and now this feature has become readily available to all users. This allows report consumers to edit SAP variables in Power BI Service with their DataQuery reports.
AI Functions in Power Query
Power BI Desktop now has AI functions in preview mode. You can extract insights from text and image data with models for text analytics and vision, and access all models from Azure Machine Learning.
LinkedIn Sales Navigator for Sales Operations
This template app allows sales operations workers to see aggregated information about how effectively Sales Navigator is being utilised. It offers insights into who is using the program, how many LinkedIn profiles match certain criteria and Social Selling Index across all users. This is available to download from AppSource.
The ribbon across the top of the Power BI program now has the same ribbon as all other Office 365 programs. This has been done in an attempt to organise the program features in a similar way, make features (such as themes) more accessible and easier to apply.
Want some Power BI Help?
Our Power BI consultancy and Power BI training courses are both ideal for businesses who want to develop their business intelligence. Our experience running comprehensive Microsoft Office courses as well as extensive consultancy to a huge range of businesses has helped us to continually identify how best to help your business. We will help you identify and understand your data using Power BI, help you develop the models and provide you with solutions that you can easily understand, and subsequently, apply.