New Slicer visualisation in Power BI

May 2, 2024 | Power BI Hints and Tips

Slicers have been available in Power BI for a long time but this new slicer visualisation provides extra features but is not so great for number or date fields.

The new slicer uses buttons to enable the data to be selected with extra functionality including changing the shape, the size of the grid and what the button looks like when you hover over it, press it or select it.

Adding the New Slicer Visualization

The new slicer visualisation is available from the list of visualizations at the top of the visualizations pane.

  1. Click on the Slicer (New) icon.
New slicer icon image

2. Add a field to use on the slicer in the Field box.

3. Only one field can be used unlike with the original slicer visualisation where multiple fields can be added depending on the layout used.

Here is an example of what the new slicer could look like.

Example of new slicer image

Formatting the New Slicer

  1. Click on the slicer already created.
  2. From the Visualizations pane select Format your Visual.

Force Selection

Force selection requires one button to be selected at all times.  This is only available if the Single Select option is switched on.

  1. From the Slicer Settings option slide Force Selection on.
Slicer settings image

Change the shape

Traditionally the shape of the buttons is a rectangle but now there are also options of a rounded rectangle or Snipped tab, both top.

  1. From the Shape option change the Shape.
Slicer shape image

2. For the Rounded rectangle the level of rounded corner can be adjusted or using Customize Style each corner can be adjusted separately.

3. For the Snipped tab, both top option the size of the top and bottom snips can be adjusted or using customize style each corner can be adjusted separately.

Layout

The layout allows the layout of the buttons to be changed.

  1. From the Layout option there are 2 sections.
Slicer layout image

2. The Layout section enables the buttons to sit in a grid or a single row or single column.  The max number of rows and columns that can be seen can be changed.  Also, the spacing between the buttons can be altered.

3. The Overflow section determines how the layout behaves if there is not enough space for all the buttons in the visualisation.  The overflow style can be continuous scroll with a scroll bar or paginated which provides an arrow to move onto the next page of buttons.  The overflow direction can also be changed to Vertical or Horizontal.

Callout Values

The callout values are the values or text that are shown on the button.  The look of these can be changed for 4 different states – Default (when nothing has been done to the button), Hover (when the button is hovered over), Press (when the button is pressed) and Selected (when the button has been selected.  Each of these are changed independently with options including Bold, Italic, underline, colour, font type and size.

  1. From the Callout values option select the State to be altered from those mentioned above.
Callout values image

2. Repeat the process for each of the different states as required.

3. The label option allows a field to be added as a label that shows below the original button label.  The formatting of this can then be changed.

Images

To add images to a button there must be a field in the original data that stores the images to be used.  Again these can be added to one or more of the states mentioned.

  1. From the Images option select the State to be altered.
slicer images image

2. Add the Field containing the images to the fieldd box and amend any other image options as required such as fit, transparency, saturation and blur.

Buttons

Once again these can be added to any of the states.  These options are used to change how the button itself looks.

  1. From the Buttons option select the State to be altered.
Slicer buttons image

2. The options that can be altered are padding, border, fill colour/picture, shadow, glow and accent bar.  Accent bar may be one you have not come across before.  This allows for a border line to be placed top, bottom, left or right on the button.  By increasing the width and changing the colour this can be a nice way of adding your branding to the buttons.

Further Reading

If you’ve enjoyed reading about the New Slicer visualization in Power BI, there are some other blogs below that you might find useful:

Want to learn more about Microsoft Power BI? Then email lara@laramellortraining.co.uk to discuss how I can help or have a look at the Microsoft Power BI Desktop Courses I run.