Power BI Report Server Update – March 2018

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 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.

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.

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.

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.

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.

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.

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.