top of page
  • Writer's pictureLachlan McLeod

Power BI Update | March 2023

Power BI's latest release brings new features for report customization and interaction, including Apply/Clear all slicers, format pane update, On-object Interaction, and new visual container improvements.


Read on below!

 

Apply all slicers button, Clear all slicers button, and Optimisation presets update

In this month's release of the Public Preview of the Optimise ribbon, a new feature has been added to allow report consumers to make slicer selections and update report visuals only after they have finished making all slicer selections. This new feature is called the Apply all slicers button and can be added in three ways: from the Optimise ribbon, from the Insert ribbon, or by choosing the Apply all slicers action on any existing button in the report. When at least one Apply all slicers button is visible on the report page, all slicers on the report page will take selection changes but will only apply them to other report visuals when the button is clicked. The Apply all slicers button allows users to make selections across multiple slicers and then apply them in one click.

Used with permission from Microsoft.

In addition to the Apply all slicers button, a Clear all slicers button has also been added to allow report consumers to quickly clear all selections in several slicers on a report page in one click.


The Optimisation preset for Query reduction has been adjusted to recommend using the Apply all slicers button instead of the single apply button for slicers. The single apply button for slicers is still available and will continue to work on existing reports.

Used with permission from Microsoft.

These new features, along with the Optimise ribbon with Pause visuals and Optimisation presets, are now on by default as a preview feature.

 

Format pane - new styling

In response to customer feedback regarding the white background and drop shadow treatment of the format pane causing dizziness, the Power BI team has implemented changes to the styling. The new format pane now features a darker background and borders instead of drop shadows when the OS setting for reduced motion is enabled. The previous format pane will be referred to as the "current format pane", while the updated version will be referred to as the "new format visual pane".

Current format pane

New format pane style

With reduce motion setting






Used with permission from Microsoft.

 

On-object interaction (Opt-in Preview)

The Power BI desktop team has introduced a new feature called On-object Interaction as a way to address user feedback about the difficulty of building and formatting visuals in the application. The team observed that new users often struggle to navigate the UI to perform simple actions such as adding data to the correct field wells or formatting text styles. Users have also instinctively tried to right-click areas of the visual expecting a menu to help. To address these issues, the team has introduced On-object, a new way to build and format visuals directly on the visual, aligning with the new "Office-like" strategy.

Used with permission from Microsoft.

The Power BI team invites users to try out the feature by turning on the preview switch in the Options menu.

Used with permission from Microsoft.

More details on the feature can be found in the On-object | Public Preview (Opt-in) documentation.

 

Visual container improvements

In this month's release, Power BI is offering three new features to improve the customisation of visual containers.


Firstly, a subtitle toggle has been added to the Title settings card of the formatting pane, which allows users to add extra context to their visuals.


Used with permission from Microsoft.

Secondly, users can add a divider line to visually separate the visual header from its contents. This can be found in the Title settings card of the formatting pane below the new "Subtitle" option.


Used with permission from Microsoft.

Thirdly, users can control the space below each component in addition to the Subtitle and Divider on their visual container. The "Spacing" setting can be found at the bottom of the Title settings card of the formatting pane.

Used with permission from Microsoft.

Finally, a new option to control the container's margin has been added to create negative space and enhance the visuals' appearance. This option can be found in the Properties card of the formatting pane.

Used with permission from Microsoft.
 

For the rest of the Power BI March 2023 update, click here, or if you would like to discuss Power BI for your business, email info@pt20.com.au or give us a call on +61 746 596 700.

Commentaires


bottom of page