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.




Query editing

Performance improvements

Other improvements

For table and matrix visuals, we have the additions of cell alignment, display units, and precision control for individual fields.

20a0af08 bb1c 446b a5fd f394a7f0ad3b Power BI Report Server Update – March 2018

We’ve also extended conditional formatting to include rule-based conditional formatting.

7cf91372 be2a 4c2b 9f2e 25a1e72f96d5 Power BI Report Server Update – March 2018

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.

0eecf5fb c763 43ed b000 cf2469355d3d Power BI Report Server Update – March 2018

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.

4679dd81 1645 4a12 a919 a7761b728e27 Power BI Report Server Update – March 2018

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.

d483b17f ecb3 4b79 a183 3688631a03ad Power BI Report Server Update – March 2018

For scatter charts, we’ve added a way to plot your data without having to group it on a category through the details bucket.

78946c72 b59d 4bb5 8b68 a9005e32b176 Power BI Report Server Update – March 2018

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.

84575a09 b912 41a5 b45b 677806a6719b Power BI Report Server Update – March 2018

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.

600cf413 a111 4766 9db9 733b20a709e7 Power BI Report Server Update – March 2018

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.

4ab55404 28c7 42a0 a4f8 3526eba4c347 Power BI Report Server Update – March 2018

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.

08f7faf7 a0d9 49b0 b201 203c6bbfaa1f Power BI Report Server Update – March 2018

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.

5fe4547f a4cf 4bef 8dae a512e8e63b2a Power BI Report Server Update – March 2018

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.

4b9ea7cd 9670 45ca a115 a160af8d16b4 Power BI Report Server Update – March 2018

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.

72f07ead 2b63 4058 ba17 0ec0a79e9617 Power BI Report Server Update – March 2018

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.

73461101 a7ca 4fd8 9841 68b4c0dd4288 Power BI Report Server Update – March 2018

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.

18d7e7e1 bb01 42a7 af87 53460fe4d689 Power BI Report Server Update – March 2018

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.

9524592b c248 4968 a106 020efdd5c350 Power BI Report Server Update – March 2018

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:

  • Basic conditional columns
  • Conditional column ranges
  • Null fallback
  • Bucketing (uniform ranges)

c7fa5844 541a 4da2 8197 ff7b8d95bce7 Power BI Report Server Update – March 2018

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:

  1. Combining additive and non-additive aggregates into single query
  2. Improved handling of queries with a large number of literals
  3. Use of a single SQL query rather than multiple for some visuals and calculations
  4. Optimized queries to reduce post-aggregation
  5. 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.

eca440e9 ae88 43fd a0d6 918d841c7d6d Power BI Report Server Update – March 2018

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.

Additional resources:

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI