Power BI Desktop lets you visualize, connect and transform your data. It is also a free application. By using Power BI Desktop, you will be able to connect with numerous sources of data, make them come together and form a data model, which will enable you to create visuals, and share them as reports among other people in your organization.

The Power BI desktop is used by people working on Business Intelligence Projects. This helps them to build reports and then share them with other people. 

The Power BI latest version update has brought many new features. In this article, I will discuss all these features.

The Features of The Update In The Power BI Latest Version

The latest update is available in a single .exe file. So, let’s see what are the latest features provided in September update.

Reporting

Text Classes and Color Themes

To write a custom theme in the JSON file is difficult, especially when it changes the whole get-up of your report. If you want to change the settings of the theme of the computer, then you would require to alter a huge number of settings to get your desired result.

Hence, to solve this problem, the color classes have been expanded located in the theme files. This will help to change the colors of the theme and the people dont have to tamper with the visual style. 

If anyone is writing some theme files, then its most likely you are utilizing some of the pre-existing color classes. These classes are like tableAccent, background, and foreground. Due to the new update, some more classes are added to the list. This will help you to make all the visual elements color just by adjusting 6 color classes.

The color classes available after the updates are:

Foreground
  1. Filter cards and filter pane & icon colors.
  2. Labels background colors.
  3. Text default color.
  4. Trend line color.
  5. Data bars axis color.
  6. Tabl and matrix values and totals front colors.
  7. Gauge callout value color.
  8. Card data labels.
  9. KPI text color.
  10. KPI goal color.
  11. Slicer item color.
  12. Slicer dropdown item front color.
  13. Map leader line color.
  14. Slicer numeric input font color.
  15. Slicer header font color.
  16. Scatter chart ratio line color.
  17. Line chart forecast line color. 
  18. Foreground Neutral Secondary
  19. Legend label color. 
  20. Label colors.
  21. Table and Matrix header font color.
  22. Axis label color.
  23. KPI trend axis color.
  24. Gauge target and target leader line color.
  25. Slicer item font color.
  26. Slicer slider color.
  27. Line chart hover color.
  28. Slicer outline color.
  29. Ribbon chart stroke color.
  30. Multi-row card title color.
  31. Button text font color.
  32. Shape map border color.
  33. Button online color.
  34. Button icon line color.
Foreground Neutral Tertiary
  1. Card category label color.
  2. Legend dimmed color.
  3. Multi-row card bar color.
  4. Multi-row card category labels color. 
  5. Funnel chart conversion rate stroke color.
Background Light
  1. Axis gridline color.
  2. Filter card background color for applied filters.
  3. Slicer header background-color.
  4. Table and matrix grid color.
  5. Shape fill color.
  6. Multi-row card outline color.
  7. Gauge arc background color.
Background Neutral
  1. Ribbon chart ribbon fill color.
  2. Table grid outline color.
  3. Shae map default color.
Background
  1. Available filter and filter pane card background color.
  2. Labels background color.
  3. Donut chart stroke color.
  4. Slicer dropdown items background color.
  5. Combo chart background color.
  6. Button fill color.
  7. Treemap stroke color.
Table Accent
  1. Overrides matrix grid outline color and table when present.

Besides these color classes, some text classes are also added to make it easier to select text styles. 

Updated Default Themes

The themes have also been updated to work with the new JSON option theme. These new themes have a wide variety and offer more features to apply themes. 

This new theme is built to work along with the design language of Microsoft. The new update is a great improvement compared to the old themes. 

The visual updates in these new themes are:

  1. It offers a smaller size of bubbles for the map visuals and scatters. 
  2. Darker, larger and more prominent text.
  3. To improve the readability, they updated the layout of the donut and the pie chart.
  4. Combo charts and lines have got wider line strokes.
  5. By default, now the background remains on for the visuals.
  6. Now, by the default setting of the matrices, the expand/ collapse is always on. 

The previous themes can also be found in the “More themes” option. 

Personalized Visualization Pane Improvement

Unpin Default Visuals

The ability to unpin the default visuals is the first update available to the personalized visual pane this month. After you have removed the built-in-visual, it will get moved under the dotted line located within the pane. This will not show up unless you are having used the visual type in the report. In those cases, it will appear under the dotted line. 

The custom and the built-in visuals have the main difference that the built-in shows up initially by default.

The reasons you would consider this as an option:

  1. You want to declutter the plane and dont want to use certain visuals.
  2. The default visual types dont interest you and want to go for some other options.
  3. As you are using a custom visual version, you will not want to unintentionally click on the built-in version

If at some point you wish to bring back the default visuals, then you just have to use the option for restoring the default visuals on the pane.

Analytics

Custom Format Strings

When you are in a modeling view, you are now capable of using a custom format string so that you can customize the way a field will look in the visuals.

To do his procedure, you first have to choose the field from the list of fields available. Then you have to choose the custom format from the formatting card in the properties pane.

After that, you have to go to the list of the format strings which are most commonly used. Alternatively, you can also write the format string in the input box. Most of the VBA style syntax is supported by Power BI with some exceptions. You need to mention the whole document for the purpose of the details.  

Then, after the format string is entered, it will soon show in the report view and the data view.

Visualizations

Certified PowerApps Visual Available

The adding of power of the app to the dashboard and the reports is done by the PowerApps marketplace visual. You can now embed your PowerApps in your dashboard or report because the PowerApps visual has brought the data and forms editing to the Power BI.

After the update, the visuals are now certified and the availability of visuals have made the use of visuals in many places.

Connectivity of Data

Enhancement of PostgreSQL Connector

1. Native Database Support

The inclusion of the query folding over a native has enhanced the performance of PostgreSQL. 

2. DirectQuery Support

It is now available in PostgreSQL which was announced last month.

Data Preparation

Copying From Data Profiling to The Clipboard

With the help of this update, it is now possible to copy the data profiling to the clipboard from the Power Query Editor for exporting data.

All the Data Profiling surface has this option of copying. 

Conclusion

These are all the updates available for the Power Bi latest version. All of these are a great improvement and offers a great feature for the users. With these updates, the connecting, visualizing and transforming of your data will be much easier.