Like every month a simple resume to know all the update of Power BI Desktop:
- Additional styles on a table, matrix and multi-row card: we can finally have some customization on table an matix and not only minimal visualization.
- Trend lines on single visuals: works on line, scatter, bubble, column, area, and combo charts. To enable the trend line, select the control, and in the Visualizations tab, Format settings, switch Trend Lines to “On”.
- New drill action – See Records: You can now allow users to see all the data records behind a data point by enabling the See Records option in the Drill ribbon.
- Map auto-zoom during drill/filter: Whenever you drill into or filter data in the map, the control will automatically zoom in to the available data points.
- In-line hierarchy labels for expanded view (Preview): When multiple categories or dimensions are added to a single axis, a few interactive options are available to the end-user. One of these is “Expand All” which flattens the hierarchy and shows all items at the lowest level, enabled via the double down arrow on the top bar of the visual or a right-click on the visual.
- Modelling operations not blocked while visuals refreshing: speeds up the modelling operations by not blocking them while visual controls are refreshing
- Time Intelligence with built-in date hierarchy fields (Preview): With this version of the Power BI Desktop you can now use DAX time intelligence functions with the built-in time intelligence functions. With the Inline hierarchy labels preview feature turned on, you can access these fields with a dot notation (e.g., Sales[InvoiceDate].[Date]). Time Intelligence feature is in Preview and needs to be enabled in File -> Options and Settings -> Options -> Preview Features before use
- Data model synonyms: In this release you can now see, edit, and add synonyms for your model. You can access synonyms in the Relationship view by selecting Modeling > Synonyms.
- Query Parameters : Users can now easily create and manage parameters within their Power BI Desktop files.
- Power BI Template files: Exporting Power BI content as a template is another new feature that will help streamline work. Power BI templates (.pbit files) include the definition of a Report, Data Model and queries, but not the actual data. Templates can be created via File -> Export -> Power BI Template, which generates a .pbit file.
- New “Online Services” category in Get Data dialog
- New Connectors:
- SharePoint Folder
- Conditional Columns: is like a SQL “Case when” but visual and more simple
- DirectQuery – Specify DirectQuery vs. Import mode in data source dialogs : The users can pick which mode they would like to use as part of the initial data source connection dialog.
- Column type indicator in Query Editor preview column headers
- Reorder Queries and Query Groups via Drag & Drop gestures:Users can now easily reorder queries and query groups within the Queries pane by selecting one or multiple objects and dragging & dropping them into their desired destination
- Query Management menu in the ribbon: This menu exposes common management operations for a query, such as Duplicate, Reference and Delete.