Power BI - Updates
Updates from Power BI!
One of the many benefits of Power BI is that the developers work tirelessly to optimize the user experience of the frontend tool for the benefit of all us users. This month, it among other things includes new visual tooltips allowing you to drill down or drill through directly from any datapoint – very useful!
As always, we have handpicked the three updates that we find most useful, which you can read much more about below:
Modern Visual Tooltips (preview):
This new function allows you to drill down/up and drill through on a datapoint directly from the datapoint without having to use the right-click menu or visual header. When choosing to drill down, the displayed visual will change to the next level in the hierarchy. As an example, this could be an overview of sales of a product filtered by country, and with this update you are now able to access the next level in the hierarchy (e.g., sales of a product filtered by city) directly from the datapoint. When choosing to drill through, the user will have the opportunity to change display to other pages where the datapoint in question can be filtered to. If the user is for example hovering Germany, a drill through option could be basket analysis or category details filtered to Germany.
Remember that this function is in preview, which means that you must activate it through settings. Furthermore, to add the function to existing reports, you must additionally activate it through report settings.
Read more about the new Modern Visual Tooltips update and learn how to use the new tooltips right here: https://powerbi.microsoft.com/da-dk/blog/power-bi-may-2021-feature-summary/#post-15345-_Toc70941229
Quickly Create Reports from SharePoint Lists (preview):
The integration between SharePoint and Power BI has now gotten much more intuitive. This means that you are now able create a customizable Power BI report directly from SharePoint based on a SharePoint list. This report can be edited and filtered directly from the new tab, and you can even publish the report to the original list in SharePoint meaning that users with access to the list can also access the report. The report will update regularly to be in sync with the list but if you make changes to the report, you will have to actively publish these to the list to save the changes.
Read more about the new Reports from SharePoint Lists update and learn how to use the new report function right here: https://powerbi.microsoft.com/da-dk/blog/quickly-create-reports-from-sharepoint-lists/
Work Side by Side with other Apps on your iPad or Andriod Tablet:
When using Power BI on a tablet, you would often want to be able to see your report while concurrently having a meeting on Teams or writing an e-mail. Until now, users had to switch between screens but with this update, user can now do split-screen setups making it much easier to gain an overview of your Power BI reports doing meetings, calls, etc.
Read more about the new Work Side by Side update and learn how to use the new tablet function right here: https://powerbi.microsoft.com/da-dk/blog/power-bi-may-2021-feature-summary/#post-15345-_Toc70941252
Once again, it is time to be updated on the newest updates in Power BI making it even easier to visualize and describe your valuable business data. As always, we have hand-picked the three updates that we find most useful. This, among other things, includes the opportunity to use Power Automate directly from a Power BI report. This allows you to act externally based on data from a report without having to leave the report.
You can read much more about the new updates right here:
Power Automate for Power BI (preview):
Power BI is an effective visualization tool often delivering eye-opening details about areas requiring external action. Based on this, Power BI has now integrated Power Automate directly from the report page allowing you to set up and possibly automate external processes reacting based on certain changes/conditions in data, or whenever you want to. Imagine having the need to inform certain employees through e-mail about a range of delays on shipments in their specific departments. As of now, you can automate this process by ex. creating buttons that automatically runs this notification.
Remember that this function is in preview, which means that you must activate it through settings.
Read more about the new Power Automate for Power BI update and learn how to use the new flow tool right here: https://powerbi.microsoft.com/en-us/blog/power-bi-april-2021-feature-summary/#post-14480-_Toc68689095
Text/CSV By Example:
Today, many Power BI users have integrated their data sources with their Power BI reports directly and with automatic updates. However, it can sometimes for some users be relevant to manually import data files. In this connection, however, there can be a lot of work in having to adapt the setup in, for example, an Excel file in relation to where Power BI should extract data and where to. To ease this process, Power BI has made it possible to set up extraction examples, so that you can apply different examples of how and where in the dataset that Power BI should extract specific data from.
Read more about the new Text/CSV By Example update and see how to use the new import function here: https://powerbi.microsoft.com/en-us/blog/power-bi-april-2021-feature-summary/#post-14480-_Toc68689106
On the more visual side of things, Power BI has made the possibility of differentiation in your reports even better. Previously, it was possible to choose between five different shapes for various illustration, buttons, or similar, but Power BI has now added an additional 16 shapes to choose from.
Read more about the New Shapes update and learn how to use the new shapes right here: https://powerbi.microsoft.com/en-us/blog/power-bi-april-2021-feature-summary/#post-14480-_Toc68689097
We have combined the previous two months of updates in Power BI in one notice, so there is much for you to dive into to make your experience in Power BI even better. This time, we have hand-picked the four updates that we find most improving for the general experience in Power BI. Among the new updates is the opportunity to connect multiple cubes live to the same report - very useful!
You can read much more about the new updates here:
DirectQuery for Power BI datasets and Azure Analysis Services (preview):
It has for a long time been possible to connect multiple cubes or datasets to the same report. However, this function has not been accessible for live connections meaning that to many it has not been an applicable functionality. Luckily, Power BI has now changed that so that you can now connect multiple live-connected cubes from for example the AFC platform directly to your Power BI report and combine them as you like.
Remember that this functionality is in preview so you must activate it through the settings.
Read more about the new DirectQuery update and learn how to set up multiple connections here: https://powerbi.microsoft.com/da-dk/blog/power-bi-december-2020-feature-summary/#_Toc58831296
Previously, the color picker in Power BI has been source of frustration as it has sometimes been troublesome to handle and has lacked the option to enter RGB color codes. This has now been adjusted so that in the future, you can easily and manageably use your organization’s color codes.
Read more about the new Color picker update and see how the new function looks right here: https://powerbi.microsoft.com/da-dk/blog/power-bi-february-2021-feature-summary/#_Toc62034803
This new and highly applicable function allows you to visually compare figures (e.g., the sales development of different departments over time) with an index (e.g., the total sales of the organization over time). If you have access to market data, you can even import external data to for example compare with the general sales in the market.
Read more about the new Comparison chart update and learn how to use the new comparison function here: https://powerbi.microsoft.com/da-dk/blog/power-bi-march-2021-feature-summary/#post-14033-_Toc65500410
X axis constant line for line charts:
With this new function, you now have the option to add a sticky, vertical line in line charts to for example mark an outlier or just a concrete point in time in a dataset. This line can be customized as you know it from Power BI regarding color, line type, etc., and it works just like the current horizontal line frequently used in Power BI.
Read more about the new X axis line update and learn how to use the new line function here: https://powerbi.microsoft.com/da-dk/blog/power-bi-march-2021-feature-summary/#post-14033-_Toc65500394