If you are wondering why is XL Intelligence reporting on April Power BI update in May – this is because April updates were released only on the 6th of May.
As we keep expanding our Power BI consultancy services, these updates help us significantly. What was not possible last month may become a new norm in the next. We introduce new features into our training courses and incorporate them into improved business intelligence solutions. Whether it’s Power BI dashboards or DAX, XL Intelligence want to ensure you’re getting the most out of Power BI.
Please see the summaries of the Power BI monthly updates:
- Power BI September 2019 update
- Power BI October 2019 update
- Power BI November 2019 update
- Power BI 2020 update summary
- Report Server January 2020 update
- Power BI February 2020 update
- Power BI March 2020 update
The April Power BI update includes new features in:
- Template Apps
- Data preparation
Personalize visuals (preview)
How many times you looked at a chart created be a report author and you couldn’t make sense of it? Different people think differently and what makes sense to one person is not obvious to another. A lot of people do not like pie charts, some people struggle with 100% stacked columns. Now you can finally change the visual in a published report.
A report author has to turn on personalisation option in Power BI desktop first. Web consumers will see additional icon for the visuals. This will allow to change visual type, legend, change axis, add measures. A user can then save their view as a bookmark and set it as default view for themselves. Those changes can even be shared!
Change detection for page refresh (preview)
Frequent automatic refreshes can become an expensive resource usage. The new feature checks for data change on the background and refreshes pages only when the data had been changed.
Relative time filter (preview)
You can now filter page/report by relative time intervals: for example by the last 5 minutes.
Rectangular lasso select across visuals
Selecting multiple visuals can be a messy affair, especially when you have visuals stacked behind each other. You can now use Lasso tool. Click anywhere in the canvas and drag around visuals you want to include in the group – all will be selected.
Conditional formatting for totals and subtotals in table and matrix
This is the feature we all were waiting for. We can now apply conditional formatting to totals and subtotals in tables and matrixes.
Direct Query support for AI visuals
Two AI visuals will now work with Direct Query: Decomposition Tree and Key Influences.
Decomposition tree now supports tooltips
Q & A update
- You can now create your own questions for Q&A to help a user with data analysis
- Teach Q&A now available for measure conditions. For example if you have “Sales” measure, you can define “top selling shops” by defining the shops with greater then average sales.
- Q&A is now available for datasets
There are some interesting additions to custom visuals. We like couple:
- Comicgen by Gramener – this new visual allows you to add comic characters with changing emotions or gestures to a report. For example, if sales are below target the character may frown, and if above – smile.
- Growth Rate Combo Chart by Djeeni – this chart is perfect for showing percentage change between two or more categories; or showing percentage change between two or more time periods.
There are a couple of new additions to the Power BI templates assortment. You can save time significantly by connecting your own data to prebuilt reports. They are listed below.
- Power Platform Center of Excellence (CoE) StartKit – provides a holistic view of the resource usage in your tenant, including environments, Power Apps apps, Power Automate flows, connectors, connection references, makers and audit logs.
- Azure Cognitive Search: analyze logs and metrics – a cloud search service with built-in AI capabilities that enrich all types of information to easily identify and explore relevant content at scale.
We have developed a variety of business intelligence solutions as a result of our Power BI consultancy.
XL Intelligence want to ensure our clients receive the best possible support. Whether they want to learn how to use Power BI themselves or have a dedicated consultant work with them to develop bespoke solutions that help their business, we are here to help.