en en ms fi da da da da ca da en da ms hbs_lat ms ms ms en da da ms ms da es da de ro en da da da da de da da de en it da da da es da da en da da da en da sv de da en da en en en en en da pt fr fr en de en sv da da da da sv da da en en en en en en it en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en ms ms en en en en pl en da da da da da en da da da da da en tr da ca en en id en en en en en en en en ms ms ms en en ml da en en nl nl da en da de de en en nl en en nl nl sv en da de de en en nl en en nl nl sv en da de de en en nl en en sv nl da en da de da en en nl en en nl nl sv en da da da en en nl en en nl nl sv en da da da en en nl en en nl nl sv en da de de en en nl en en nl nl da en da de de en en nl en en nl nl da en da de de en en nl en en nl en da ms en en en sv da fr da it de en ms ms en it da da de en en en sv da en da en da da en da da da hbs_lat da de de de el de en en tr en en en en en en en es es fi fr fr fr fr hu it it ja ko da nl nl pl pt pt ru sv th tr zh zh ar he
Power BI Desktop April Feature Summary | Microsoft Power BI-blog | Microsoft Power BI
Office 365 + Power BI
This month we are delivering a number of great capabilities. We are introducing Quick measures, which is a huge update to our Quick Calcs experience. We have some very exciting updates in both data connectivity and query editing, including allowing you to connect to datasets on te Power BI service, so you can create your model just once and use it in multiple reports. We also have an innovative new way to add columns in your query editor: add column by example. Additionally, we are extending our matrix preview with even more features and releasing a preview of Q&A in Spanish.
Continue reading to learn about all these great features and make sure to register for te 2017 Microsoft Data Insights Summit to see all te new and exciting Power BI features in person!
Here’s te complete list of April updates:
New matrix visual enhancements: column sorting, column resizing, and word wrapping (preview)
Quick measures and show value as (preview)
Connect to datasets in te Power BI service (preview)
Redshift Connector: beta support & publish to Power BI service
SAP HANA & BW Connectors: enhancements to parameter input experience
Group by – basic mode
For a summary of te major updates, you can watch te following video:
If your field names aren’t te most business user friendly, or your chart layout needs more explanation, you can now rename your axis titles to anything you want. This option is with te other title options under te axis card in te formatting pane.
Find more information about axis title renaming in te following video:
New matrix visual enhancements: column sorting, column resizing, and word wrapping (preview)
Last month, we released a preview of a new matrix visual with lots of exciting new features, which you can read about in our last blog post. This month, we are adding to te fun with three updates to this preview: column sorting, resizing, and word wrapping.
You can sort te matrix now by te grand total and row headers ascending or descending, just as you could with te original matrix.
We’ve also added te resize functionality we had in te original matrix to te preview. Just hover over te area between te two columns and your cursor will change to indicate you can click and drag to resize.
Finally, you can now word wrap column headers, row headers and values in te matrix preview. Each one can be turned on in te formatting pane under te corresponding card: column headers, row headers, and values.
We’ve heard lots of great feedback from te survey we launched last month and have plans to bring many of te features you requested to te matrix in te near future. For example, we are working on:
Updating te table visual to support cross highlighting
Adding control over visibility of individual subtotals
Find more details te updates to te matrix preview in te following video:
Quick measures and show value as preview
This month we are previewing a major update to our Quick Calcs experience. Once you turn te preview on by selecting Quick measures under File > Options and settings > Preview features, you’ll see two new options for numerical columns and measures: Show value as and Quick measures. These options will replace te previous Quick Calcs option in te field menu.
Show value as is a quick way to change te way your values appear in a chart or table. These correspond to what was previously in te Quick Calcs dialog. Since you no longer need to open a dialog, it is now very quick to update how your values show in any given chart.
Using quick measures is a very fast way to create new measures based on measures and numerical columns in your table. This means you can now deliver expert level calculations with no DAX knowledge. These new measures are now part of your model and can be used in any of your charts. This means you can use them as a great learning tool or as a starting place for more advanced calculations since te auto-generated DAX is available to you.
You can create measures based on 19 different calculations across 5 different categories:
These calculations let you apply different aggregates at different levels in your data. For example, you could sum revenue up to te month level and then take an average of that total to display at te year level.
These calculations allow you to calculate values for a specific category in a column, or compare values to a specific baseline. For example, you could calculate your sales for just a specific category of your products.
If you need a measure that shows period-to-date or period-over-period values, te time intelligence calculations let you do this. DAX has many built-in functions that these quick measures make simple to use.
This calculation is similar to te YTD calculation, but lets you apply a running total over any field, not just dates.
These calculations run simple mathematical functions, which can become powerful when chained together.
You can create a quick measure by selecting Quick measures from te field menu, either in te field well of a chart or from te field list.
In te dialog, you can pick any of te 19 different calculations to perform on te selected measure. Depending on te calculation, you’ll have different required parameters you’ll need to fill in. You can also change te fields being used in te calculation using te field list on te right half of te dialog.
After you fill in all te required parameters and click OK, te quick measure is now part of your model and available to use in your other visuals. It’ll also be added to your existing visual if you launched it from te Field Well of a visual.
If you want to learn more about this feature, check out our quick measures deep dive blog.
Find more details about quick measures in te following video:
Q&A in Spanish (preview)
We are very excited to announce a preview of Q&A in Spanish. Te first step to using Q&A in Spanish is to mark te language of your model as Spanish. To do this, you first must turn on te preview feature by checking Spanish language support for Power BI Q&A under File > Options and settings > Preview features.
Once te feature is on, you’ll find a Language option in te Modeling tab of te Relationship view.
Once your model language is set to Spanish, you can now publish this report to te Power BI service and be able to ask any question you want in Spanish!
For example, I can now ask Q&A for te countries and number of medals they won in te Rome ’60 Olympics in Spanish and get te result back!
If you have any Spanish language models, be sure to give this feature a try!
Learn more about te Spanish Q&A preview in te following video:
Connect to datasets in te Power BI service
You can now connect to a dataset that exists on te Power BI service. This feature is great when you are part of a team and you all want to work off te exact same model. You can craft your model only once, publish it to te Power BI service to create a dataset, and then everyone can create other Power BI Desktop reports off of it.
You’ll find this new connector under Get Data > Online Services > Power BI service.
You will see a list of all te workgroups you are a part of. Expand one and you’ll see all te datasets that you have edit access to. This includes any datasets in your workspace and datasets in shared workspaces.
Select a dataset and you will be live connected to that model in te cloud. You can now create a new report and publish it up to te service to share out. Of course, you can always download te file again if you ever need to.
Since this is a live connection, you won’t have permission to do any modeling and cannot join te data with any other sources. To do these type of changes, you will need to make them in te source file and republish to te service for other reports to consume.
This is a preview feature, so you will need to turn it on in by selecting Power BI Service Live Connection under File > Options and settings > Preview features.
Learn more about connecting to datasets in te Power BI service in te following video:
Redshift Connector: beta support & publish to Power BI service
We’re making te Redshift connector available as beta in this release, so you no longer need to enable it as a preview feature. Te Redshift connector can be found under te Database category within te “Get Data” dialog.
Redshift-based reports have been supported in te Power BI service since March. Now, we’re also enabling te Publish button in Power BI Desktop, so you can publish your Redshift-based reports directly from Power BI Desktop. Learn more about te Redshift connector in our dedicated blog.
Learn more about te Redshift connector in te following video:
SAP HANA & BW Connectors: enhancements to parameter input experience
We’re improving te Parameter Input UX for SAP HANA & BW connectors in a couple of ways.
Ability to filter down te list of parameters to “only required parameters”
Improvements to te single/multi-selection input controls
We’re moved away from dropdown menus and started using a popup dialog for both single selection and multi selection controls. This new dialog allows you to see both te ID and Caption for each parameter value, as well as search within te list of values by any of these two fields. This should make it easier to provide input values compared to te previous experience that only allowed to input IDs.
Learn more about te updates to te SAP HANA and BW connectors in te following video:
Add column by example
This month we’re adding a new smart data exploration capability to te Query Editor that learns from your examples. Based on your examples of te desired output, we will detect te transformations required and create a new column.
This is an innovative approach to defining query steps within te Query Editor that simplifies te process for beginners as they no longer need to come up with “a strategy” for how to transform or extract data from other columns, or how to define those transformations in te Query Editor.
Watch this feature in action in te following video:
We’re just getting started with this feature and plan to make improvements incrementally in subsequent releases. A list of all currently supported data transformations is available from te “Help” link in te command bar while using this feature. Your feedback about this feature is really critical to us in order to influence future enhancements, so please do not hesitate to contact us via te “Send Feedback” button, also available from te command bar.
Split column (by delimiter/number of characters) into rows
We’ve added a new option within te “Split Column By Delimiter” and “Split Column by Number of Characters” transformation dialogs that allows you to specify whether to split into new columns (default behavior) or split into new rows.
This new option can be found under te “Advanced Options” section in these two dialogs.
Learn more about te update to te Split Column feature in te following video:
Group by – basic mode
We have added a Basic mode to te Group By transform dialog that simplifies te UI for you to group by a single column and define a single output column. You can switch between Basic and Advanced modes within te Group By dialog by selecting te desired option at te top of te dialog.
Learn more about te basic mode of te Group by feature in te following video:
When working with tables that have a large number of columns, it can be hard to scroll in te Query Editor Preview in order to find te column that you want to apply transformations to.
In this month’s release, we’re adding a new “Go To Column” option within te Home tab in te Query Editor ribbon that allows you to search within te list of columns and select te column that you would like to scroll to and select.
Learn more about Go to column in te following video:
That’s all for this month! We hope that you enjoy this new update and continue sending us valuable feedback about our product. Please don’t forget to vote for other features that you would like to see in te Power BI Desktop in te future.
And don’t forget to register for te 2017 Microsoft Data Insights Summit! I can’t wait to see everyone there.
Add column by example
Tilmeld dig Power BI-nyhedsbrevet
Tilmeld dig nedenfor for at modtage de seneste nyheder fra Power BI direkte i din indbakke.
Land Afghanistan Albanien Algeriet Amerikansk Samoa Andorra Angola Anguilla Antarktis Antigua og Barbuda Argentina Armenien Aruba Aserbajdsjan Australien Bahamas Bahrain Bailiwick of Jersey Bangladesh Barbados Belgien Belize Benin Bermuda Bhutan Bolivia Bonaire Bosnien-Hercegovina Botswana Bouvetøen Brasilien Brunei Darussalam Bulgarien Burkina Faso Burundi Cabo Verde Cambodja Cameroun Canada Caymanøerne Chile Cocosøerne (Keelingøerne) Colombia Comorerne Congo Cookøerne Costa Rica Côte d'Ivoire Curaçao Cypern Danmark De Amerikanske Jomfruøer De Amerikanske oversøiske øer De Britiske Jomfruøer De Forenede Arabiske Emirater Den Centralafrikanske Republik Den Demokratiske Republik Congo Den Dominikanske Republik Det Britiske Territorium i Det Indiske Ocean Det palæstinensiske selvstyre Djibouti Dominica Ecuador Egypten El Salvador Eritrea Estland Etiopien Falklandsøerne Fiji Filippinerne Finland Frankrig Fransk Guyana Fransk Polynesien Franske Oversøiske Områder Færøerne Gabon Gambia Georgien Ghana Gibraltar Grenada Grækenland Grønland Guadeloupe Guam Guatemala Guernsey Guinea Guinea-Bissau Guyana Haiti Heard- og McDonaldøerne Honduras Indien Indonesien Iran Irland Island Isle of Man Israel Italien Jamaica Jan Mayen Japan Jordan Juleøen Kasakhstan Kenya Kina Kirgisistan Kiribati Korea Kosovo Kroatien Kuwait Laos Lesotho Letland Libanon Liberia Liechtenstein Litauen Luxembourg Madagaskar Malawi Malaysia Maldiverne Mali Malta Marokko Marshalløerne Martinique Mauretanien Mauritius Mayotte Mexico Mikronesien Moldova Monaco Mongoliet Montenegro Montserrat Mozambique Namibia Nauru Nederlandene Nepal New Zealand Nicaragua Niger Nigeria Niue Nordmakedonien Nordmarianerne Norfolk Island Norge Ny Kaledonien Oman Pakistan Palau Panama Papua Ny Guinea Paraguay Peru Pitcairn Polen Portugal Puerto Rico Qatar Reunion Rumænien Rwanda Saba Saint Barthélemy Saint Kitts og Nevis Saint Lucia Saint Martin Saint Pierre og Miquelon Saint Vincent og Grenadinerne Salomonøerne Samoa San Marino São Tomé og Príncipe SAR Hongkong SAR Macao Saudi-Arabien Schweiz Senegal Serbien Seychellerne Sierra Leone Singapore Sint Eustatius Sint Maarten Slovakiet Slovenien Somalia South Georgia og De Sydlige Sandwichøer Spanien Sri Lanka St. Helena, Ascension, Tristan da Cunha Storbritannien Sudan Surinam Svalbard Sverige Swaziland Sydafrika Sydsudan Syrien Tadsjikistan Taiwan Tanzania Tchad Thailand Timor-Leste Tjekkiet Togo Tokelau Tonga Trinidad og Tobago Tunesien Turkmenistan Turks- og Caicosøerne Tuvalu Tyrkiet Tyskland Uganda Ukraine Ungarn Uruguay USA Usbekistan Vanuatu Vatikanstaten Venezuela Vietnam Wallis og Futunaøerne Yemen Zambia Zimbabwe Ækvatorialguinea Østrig Ålandsøerne
Jeg vil gerne modtage Power BI-nyhedsbrevet. Erklæring om beskyttelse af personlige oplysninger.
Deltagelse kræver, at dine personlige oplysninger overføres til andre lande, som Microsoft driver forretning i, herunder USA. Når du sender denne formular, accepterer du overførslen af dine data uden for Kina. Erklæring om beskyttelse af personlige oplysninger.
Hvad er Power BI?
Power BI er en pakke med virksomhedsanalyseværktøjer til dataanalyse og vidensdeling. Overvåg din virksomhed, og få hurtigt svar med omfattende dashboards, der er tilgængelige på alle enheder.
Få de seneste nyheder fra Power BI-blog
Abonner via mail Du skal angive en gyldig mailadresse Du har angivet en personlig mailadresse. Angiv din arbejds- eller skolemailadresse. Noget gik galt. Prøv igen senere.
Beskyttelse af personlige oplysninger og cookies