How to Make Slicer Horizontal in Power BI

Power BI slicers are a fantastic way to filter your report data, but their default vertical layout can take up valuable screen space. By changing a slicer from a vertical list to a horizontal bar of buttons, you can create a clean, app-like navigation experience for your users. This quick guide will walk you through exactly how to make a slicer horizontal, customize its appearance, and use it effectively in your dashboards.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Exactly is a Power BI Slicer?

In Power BI, a slicer is a type of on-canvas visual that filters the other visuals on a report page. Think of it as an interactive filter that any user can click to "slice and dice" the data. Instead of using the Filters pane, which can feel a bit technical for some viewers, slicers provide an obvious and intuitive way to explore a dataset.

For example, you could use a slicer to filter a sales report by:

• Year
• Product Category
• Sales Region
• Store Manager

When a user selects an option in the slicer (like the year "2023"), all related visuals on the page - charts, maps, and tables - instantly update to show data only for that year. By default, these slicers appear as a vertical list of options, which works fine but isn't always the most efficient use of your report's real estate.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Should You Use a Horizontal Slicer?

Making your slicer horizontal might seem like a small design choice, but it can have a big impact on the usability and feel of your report. Here are a few key benefits:

• Saves Vertical Space: Reports are often constrained by height. Placing slicers horizontally at the top or bottom of the page frees up prime vertical space for more important data visualizations like charts and graphs.
• Intuitive Navigation: A horizontal bar of buttons at the top of a page feels familiar, mimicking the navigation menus on websites and applications. This makes your report more intuitive for users to interact with.
• Modern Aesthetic: Horizontal slicers, often styled as sleek buttons or tiles, can give your dashboard a more modern, polished, and professional look compared to a standard vertical list or dropdown menu.
• Ideal for 'Header' Sections: They fit perfectly into the header area of a report, creating a designated control panel for high-level filters like date ranges, business units, or geographical regions.

Step-by-Step: How to Make a Slicer Horizontal in Power BI

Switching a slicer from vertical to horizontal is incredibly easy. All it takes is a few clicks in the formatting options. Follow these simple steps.

Step 1: Add a Slicer to Your Report

First, you need a slicer. If you already have one, you can skip to the next step. If not:

1. Go to the Visualizations pane on the right-hand side of Power BI Desktop.
2. Click the Slicer icon to add a new slicer visual to your report canvas.
3. With the new slicer selected, drag the data field you want to filter by from the Data pane into the "Field" well of the slicer visual. For this example, we’ll use a "Product Category" field.

At this point, you'll have a standard vertical list slicer that shows your product categories with checkboxes.

Step 2: Change the Slicer Style to "Tile"

This is the magic step. The "Tile" style is what converts the slicer's behavior from a list to a set of selectable buttons.

1. Select your slicer visual on the report canvas.
2. In the Visualizations pane, click the Format your visual icon (it looks like a paintbrush).
3. Expand the Slicer settings section.
4. Click on the Options dropdown.
5. Change the Style from the default Vertical list to Tile.

You’ll immediately see the slicer’s appearance change. Instead of a list with checkboxes, you now have a grid of rectangular buttons.

Step 3: Adjust the Slicer's Shape to Be Horizontal

Power BI has now turned your list into tiles, but they are likely arranged in a grid or a vertical column. To make it a single horizontal row, all you need to do is resize the visual's container.

1. Click on the slicer visual to see its sizing handles (the white dots around the border).
2. Drag the bottom middle handle upwards to decrease the height of the slicer container until there's only room for a single row of tiles.
3. Drag the side handles left or right to make the slicer wider, spanning across the top of your report as needed.

As you resize the container, Power BI will automatically rearrange the tiles to fit the shape you've created. By making it short and wide, you force the tiles into that clean, horizontal layout.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Customizing Your Horizontal Slicer

Now that you have a functional horizontal slicer, you can refine its look and feel to match your report's design and improve the user experience.

Styling Your Slicer Like Buttons

Head back to the Format your visual pane to style the tiles. Here are a few common adjustments:

• Turn off the Header: By default, the slicer shows a title (e.g., "Product Category"). If the context is clear, you can turn this off for a cleaner menu. Go to General > Title and toggle it off. Or, within the visual-level settings, you will find Slicer header where you can turn it off.
• Adjust Tile Colors: Under Values, you can change the Font color and Background color for the default, hovered, and selected states of the tiles. This gives users clear visual feedback when they click a button.
• Add Borders and Shadows: Add a subtle Border under the Values section to make each tile more distinct. For a modern dashboard, go to General > Effects and add a Shadow to make the entire slicer bar "pop" off the page.

Single Select vs. Multi-Select

Sometimes you only want users to be able to select one option at a time. In the Format visual pane, go back to Slicer settings > Selection.

• Turn On Single Select: Toggling this on forces the slicer to function like radio buttons. When a user clicks a new option, the previous one is automatically deselected.
• Turn Off Multi-select with CTRL: By default, users must hold the CTRL key to select more than one option. Turning this off allows them to easily click multiple tiles to select or deselect them without needing the keyboard.

Using the 'Responsive' Toggle

Under Slicer settings > Options, you'll see a Responsive toggle. When this is turned on, the tiles will dynamically flow and resize to best fit the size and shape of the slicer container. This can be especially useful for reports that might be viewed on different screen sizes, though you may need to play with it to get your desired layout.

Troubleshooting Common Slicer Issues

If your slicer isn't behaving as expected, here are solutions to a couple of common problems.

"My Tiles Are Still in a Grid, Not a Single Row."

This is the most common issue, and the fix is simple. Your slicer's container is too tall. Click on the slicer and drag the bottom edge up until the box is short enough that only one row of tiles can fit inside. Then, make it wider to spread the tiles out horizontally.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

"I Have a Date Slicer and I Don't See the 'Tile' Option."

Correct. If you create a slicer with a date field, Power BI defaults to a "between" style slider for picking a date range. To use tiles, you first have to tell Power BI to treat the dates as categories.

1. Select the date slicer.
2. In the Format visual pane, go to Slicer settings > Options.
3. Change the Style from Between to Vertical list.
4. Now, the Style options will update, and you can select Tile from the menu.

This will create a tile for each individual date, year, or month, depending on how your date field is configured.

Final Thoughts

By transforming a standard vertical slicer into a horizontal tiled bar, you can dramatically improve the layout, interactivity, and professionalism of your Power BI reports. This simple formatting trick is a hallmark of thoughtful dashboard design, allowing you to save space while creating a user-friendly navigation system.

Ultimately, a good dashboard makes it easy to get answers from your data. While mastering details in tools like Power BI is a great skill, sometimes the faster path to insight is to skip the setup entirely. To help teams with this, we've focused on eliminating the manual work of building reports altogether. With Graphed, you can connect your data sources - like Google Analytics, Shopify, or Salesforce - and use plain English to build real-time dashboards in seconds, freeing you up to focus on strategy instead of report configuration.