en en ms fi fi fi ms fi fi fi fi fi ms hbs_lat ms sl ms fi fi fi ms ms fi fi it fi en fi fi en fi fi fi fi fi fi fi fi fi fi fi fi fi fi sq fi en fi fi fi fi fi eu fi fi fi de id fi fi fi fi fi fi fi fi fi fi fi fi fi tr fi fi fi ms en en en en fi en en ru en en en en en en en en en en en ru 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 ja en en en en en en en en en en en en en en en en en ms ms en en fi fi fi fi fi fi fi fi fi fi fi fi fi fi ca en en id en en en en en en en en ms ms ms en en ml fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi en fi ms en en en fi vo fi fi fi fi fi ms sl fi fi en fi fi fi fi de fi fi id fi en fi fi sv fi fi fi 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 nb nl nl pl pt pt ru sv th tr zh zh ar he
Power BI Report Server Update – March 2018 | Microsoft Power BI – blogi | Microsoft Power BI
Office 365 + Power BI
Today, we’re pleased to announce the release of a new version of Power BI Report Server that contains several new features customers have been anxiously waiting for, including bookmarking, syncing slicers, and quick measures. This release is supported for production workloads, so you should feel free to upgrade your production environment to take advantage of all of these new capabilities.
Below, you’ll find a summary of all the features added in this release with links to more detailed information.
For table and matrix visuals, we have the additions of cell alignment, display units, and precision control for individual fields.
We’ve also extended conditional formatting to include rule-based conditional formatting.
Now, if you have specific business logic to reflect in your table or matrix, you can create rules to conditionally color the background or font color of a column.
Cartesian charts & maps
For data labels on bar and column charts, you can now overflow your data labels past the bar’s boundary. Additionally, for Cartesian charts and maps, you can also control the background color and transparency.
There are new formatting options for the axis of bar and column charts as well. You can control the padding between categories and increase the percentage of the chart used for axis labels.
For scatter charts, we’ve added a way to plot your data without having to group it on a category through the details bucket.
If you are using our Bing maps with latitude/longitude data, we’ve enabled high density sampling that better preserves the shape of your data while also surfacing outliers.
We added two new features for our slicer visual. The first is responsive slicers, which lets you resize them to a variety of different sizes and shapes, from horizontal to square to vertical, and the values in the slicer responsively rearrange themselves as you do. For relative date slicers, we also have a feature to let you set a specific anchor date instead of it always being relative to today.
Our new bookmarking feature lets you save specific states of your report. This state can include filters, slicers, cross-highlighting, what charts are visible or not (set through the selection pane), and everything else that makes up your current view. You also have the flexibility to control what part of the report’s state is included in a bookmark.
Once you have several bookmarks, you can then play through those states in a specific order to tell a story. You can also tie a specific state of your report to images or shapes, and when someone clicks on that image, it will load that specific state. This lets you set up custom navigation and create an interactive app-like report that changes as users click around.
To make your report more app like, you can also hide pages in your report. In addition to letting you hide work in progress, this also lets you hide pages you don’t want users to navigate to directly and force them to reach that page through bookmark links or drillthrough.
You can also disable the visual header in reading mode which can give your reports a much cleaner and app-like look.
We’ve also added several reporting features to improve interactivity. You can now cross-highlight across multiple charts on a page.
As a report creator, you can also sync slicers across multiple pages of your report. If you set this up, if a user selects a specific slicer value on one page of their report, it will apply to any report pages that are synced with it.
If you have a report connected to a slow dataset, we give you report options to help reduce the number of queries being sent. From one place, you can add an apply button to all slicers and filters in your report. This means users can make as many modifications to their slicer or filter as they want and then once ready apply it. From here, you can also easily turn off cross-highlighting for your report.
In addition to add new reporting features, we’ve added improvements that make easier for authors to create reports. We’ve improved the default placement of visuals when they are added to a report page, so you don’t have to resize and move the visuals as much. When you do need to select and rearrange objects on your report, you can easily select and change the z-order of visuals through the selection pane.
Once you have your layout set and all you need to do is format and test your report, it can be easy to accidently move visuals while clicking on them. To help with this, we’ve added a way to lock visuals in your report, so they can’t be moved or resized. When formatting your visuals, we have so many formatting options now for visuals that it can be hard to find what you are looking for, so we’ve added a search box to the formatting and analytics panes.
Lastly, if you have multiple people editing your reports, you can add descriptions to the fields of your model. This is a great way for everyone to understand what fields they should use and how measures are being calculated.
We want to make it as easy as possible for you to analyze your data, including helping you create new DAX measures. Quick measures is a new feature that lets you quickly create new measures based on other fields in your table. These new measures become part of your model and can be used in any of your charts, just like manually created DAX calculations. You can also see the underlying DAX and edit it if you need to tweak the results.
Another DAX improvement is the addition of two new DAX functions that help if you're working with date-time data across timezones. UTCNOW() and UTCTODAY() will always return the current time or date in UTC so you can guarantee consistent results wherever you are.
If you have your own date table, you can now mark them as a date table in Power BI. We will then remove our built-in date tables, and you can start using this date table in your datetime quick measures.
When analyzing your data, drilling down can help you find interesting insights. With this update, we are adding the ability for other visuals on your report to be filtered as you drill down in a visual, which will help you find even more insights in your data.
The last analytics feature for this release is extending our cell-level formatting support to multi-row cards. This means that for table, matrix, single value cards, and multi-row cards, cell-level formatting defined in your multi-dimensional Analysis Services (AS) model will automatically flow through and be applied.
For this update, we’ve made an improvement to our query editor. We’ve added support for generating “Conditional Columns” transforms as part of the “Add Column From Examples” experience. This addition opens up a lot of additional scenarios for “Add Column From Examples” including:
This new version of Power BI Report Server also has several major performance improvements. This include updates in our filtering implementation, which improves performance for certain scenarios, such as when using strings. We also have many improvements to the performance of reports using DirectQuery. We expect some improvement to many queries and substantial improvement in particular cases. The key performance improvements are:
Combining additive and non-additive aggregates into single query
Improved handling of queries with a large number of literals
Use of a single SQL query rather than multiple for some visuals and calculations
Optimized queries to reduce post-aggregation
Optimized use of TREATAS in calculations.
You’ll also see improvements when opening and saving large files and when using the “Show items with no data” feature in visuals.
Lastly, there are a few improvements that don’t fall into any category. We’ve added a new option to our Help ribbon, Consulting Services. From the new Consulting Services resource on the Help ribbon, you can explore a wide variety of curated fixed price, fixed scope, and fixed duration consulting services from our vibrant partner community.
We’ve also updated our Power BI Desktop error reporting experience in this update. If you hit an exception while using Power BI, you’ll be shown a dialog where you can optionally send us information to help us investigate the issue and improve the Desktop. You’ll be able to do this completely inside Power BI Desktop. This new experience is also hooked into Windows Error reporting, so you can view your previous error information in the same place as errors from other Windows applications.
That’s all for this update! We hope that you enjoy these updates and continue sending us your feedback.
Check out the documentation
Read more about Power BI Report Server at PowerBI.com
Follow @MSPowerBI on Twitter
Power BI Report Server
Tilaa Power BI -uutiskirje
Rekisteröidy alla, niin saat uusimmat Power BI -tiedot suoraan Saapuneet-kansioon.
Maa Afganistan Ahvenanmaa Alankomaat Albania Algeria Amerikan Samoa Andorra Angola Anguilla Antarktis Antigua ja Barbuda Argentiina Armenia Aruba Australia Azerbaidžan Bahamasaaret Bahrain Bangladesh Barbados Belgia Belize Benin Bermuda Bhutan Bolivia Bonaire Bosnia ja Hertsegovina Botswana Bouvet'nsaari Brasilia Brittiläinen Intian valtameren alue Brittiläiset Neitsytsaaret Brunei Bulgaria Burkina Faso Burundi Cabo Verde Caymansaaret Chile Cookinsaaret Costa Rica Côte d'Ivoire Curaçao Djibouti Dominica Dominikaaninen tasavalta Ecuador Egypti El Salvador Eritrea Espanja Etelä-Afrikka Etelä-Georgia ja Eteläiset Sandwichsaaret Etelä-Sudan Etiopia Falklandinsaaret Fidži Filippiinit Färsaaret Gabon Gambia Georgia Ghana Gibraltar Grenada Grönlanti Guadeloupe Guam Guatemala Guernsey Guinea Guinea-Bissau Guyana Haiti Heard ja McDonaldinsaaret Honduras Hongkong, erityishallintoalue Huippuvuoret Indonesia Intia Iran Irlanti Islanti Israel Italia Itävalta Jamaika Jan Mayen Japani Jemen Jerseyn voutikunta Jordania Joulusaari Kambodža Kamerun Kanada Kazakstan Kenia Keski-Afrikan tasavalta Kiina Kirgisia Kiribati Kolumbia Komorit Kongo Kongon demokraattinen tasavalta Kookossaaret Korean tasavalta Kosovo Kreikka Kroatia Kuwait Kypros Laos Latvia Lesotho Libanon Liberia Liechtenstein Liettua Luxemburg Macao, erityishallintoalue Madagaskar Malawi Malediivit Malesia Mali Malta Mansaari Marokko Marshallinsaaret Martinique Mauritania Mauritius Mayotte Meksiko Mikronesia Moldova Monaco Mongolia Montenegro Montserrat Mosambik Namibia Nauru Nepal Nicaragua Niger Nigeria Niue Norfolkinsaari Norja Oman Pakistan Palau Palestiinalaishallinto Panama Papua-Uusi-Guinea Paraguay Peru Pitcairn Pohjois-Makedonia Pohjois-Mariaanit Portugali Puerto Rico Puola Päiväntasaajan Guinea Qatar Ranska Ranskan eteläiset alueet Ranskan Guayana Ranskan Polynesia Réunion Romania Ruanda Ruotsi Saba Saint Barthélemy Saint Kitts ja Nevis Saint Lucia Saint Martin Saint Vincent ja Grenadiinit Saint-Pierre ja Miquelon Saksa Salomonsaaret Sambia Samoa San Marino São Tomé ja Príncipe Saudi-Arabia Senegal Serbia Seychellit Sierra Leone Singapore Sint Eustatius Sint Maarten Slovakia Slovenia Somalia Sri Lanka St. Helena, Ascension, Tristan da Cunha Sudan Suomi Suriname Swazimaa Sveitsi Syyria Tadžikistan Taiwan Tansania Tanska Thaimaa Timor-Leste Togo Tokelau Tonga Trinidad ja Tobago Tšad Tšekin tasavalta Tunisia Turkki Turkmenistan Turks- ja Caicossaaret Tuvalu Uganda Ukraina Unkari Uruguay Uusi-Kaledonia Uusi-Seelanti Uzbekistan Wallis ja Futuna Vanuatu Vatikaanivaltio Venezuela Vietnam Viro Yhdistyneet arabiemiirikunnat Yhdistynyt kuningaskunta Yhdysvallat Yhdysvaltain Neitsytsaaret Yhdysvaltain pienet erillissaaret Zimbabwe
Haluan saada seuraavan Power BI -uutiskirjeen. Tietosuojatiedot.
Osallistuminen edellyttää henkilökohtaisten tietojesi siirtämistä muihin maihin, joissa Microsoft toimii, muun muassa Yhdysvaltoihin. Lähettämällä tämän lomakkeen suostut tietojesi siirtämiseen Kiinan ulkopuolelle. Tietosuojalauseke.
Mikä on Power BI?
Power BI on yritysanalytiikan työkalupaketti tietojen analysointiin ja merkityksellisten tietojen jakamiseen. Seuraa liiketoimintaa ja hanki nopeasti vastauksia monipuolisista raporttinäkymistä, joita voi käyttää kaikissa laitteissa.
Hanki viimeisimmät uutiset Power BI -blogista
Tilaa sähköpostitse Sinun on annettava kelvollinen sähköpostiosoite Olet antanut henkilökohtaisen sähköpostiosoitteen. Anna työpaikan tai oppilaitoksen sähköpostiosoite. Tapahtui virhe. Yritä myöhemmin uudelleen.
Näytä kaikki ladattavat tiedostot