How to Format Slicer in Power BI

Slicers are one of the most useful interactive elements in any Power BI report, giving users the power to filter data with a single click. But their default look can be a bit plain and might not fit the design of your dashboard. This guide will walk you through exactly how to format slicers in Power BI, covering everything from simple color and font changes to advanced settings that can dramatically improve your report's usability.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

First Things First: What is a Slicer?

In Power BI, a slicer is a type of on-canvas visual filter. Instead of using the Filter pane, report consumers can click directly on items in the slicer to filter the other visuals on the page. It's an intuitive way to let your audience explore data based on specific categories like date ranges, product types, geographical regions, or departments.

Formatting these slicers is important for a few key reasons:

• Improved User Experience: A well-designed slicer is easier to understand and use.
• Brand Consistency: Customized slicers can be styled to match your company's branding, creating a cohesive and professional report.
• Guided Analysis: Strategic formatting can draw attention to key filters and guide users toward the most important ways to segment the data.

Creating and Finding Slicer Format Settings

Before you can format a slicer, you need to create one. If you already have one on your report, you can skip to the next section.

How to Add a Slicer

1. Make sure no visuals are selected on your report canvas.
2. In the Visualizations pane, click the Slicer icon.
3. A blank slicer template will appear on your canvas.
4. Drag the data field you want to filter by from the Data pane into the "Field" well of your new slicer. For example, you could drag in "Region" or "Product Category."

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Locating the Formatting Controls

With your slicer selected on the canvas, look to the Visualizations pane on the right. You'll see a paintbrush icon labeled "Format your visual." Clicking this opens up all the formatting options, which are divided into two main tabs: Visual and General.

• The Visual tab controls elements specific to the slicer itself, like the selection controls and values.
• The General tab controls settings that apply to most visuals, such as the title, background, and borders.

Let's break down the most impactful settings within each tab.

Customizing Slicer Settings (The "Visual" Tab)

This is where you'll spend most of your time customizing the core functionality and appearance of the slicer items. Here are the key sections to focus on.

1. Slicer settings

This section is crucial as it determines how the user interacts with the slicer. The "Style" dropdown lets you choose the slicer type. The options you see will change based on the type of data (text, number, or date).

• List: The default for text fields. It displays all possible values in a vertical list. Ideal for a smaller number of options.
• Dropdown: This converts the slicer into a compact dropdown menu. It's a fantastic space-saver for dimensions with many values, like "Customer Name" or "City."
• Between: This is for numeric or date fields. It creates a slider control that allows users to select a range between two values.
• Relative Date/Time: A very powerful option for date fields, letting users filter by dynamic periods like "Last 30 days," "This Quarter," or "Next 2 months."

You’ll also find two other important toggles here:

• Show "Select all" option: Adds a "Select all" choice to the top of the slicer, making it easy for users to quickly see all data before making a selection.
• Selection Control: Turn on "Multi-select" to allow users to select multiple items (by holding Ctrl + click). Turn on "Single select" to force users to choose only one item at a time. The default allows for multi-select.

2. Slicer header

The slicer header is the text at the top of the slicer that's automatically populated from your data field's name (e.g., "Region"). You can turn it off completely or format it.

• Text: Customize the title text itself without renaming the data field. You can change "ProductCategory" to the more user-friendly "Select a Category."
• Font: Change the font family, size, color, and apply bold, italic, or underline stylings.
• Border: Add top, bottom, or frame borders to visually separate the header from the selection items.
• Background: Give the header its own background color.

3. Values

The "Values" section formats the actual clickable items inside your slicer ("North," "South," "East," "West," for example). This is where you can make the biggest visual impact.

• Font: Just like with the header, you have full control over the font family, size, color, and style. Ensure the text is large enough to be easily readable.
• Foreground and Background Color: Assign a default background color and a different one for the selected state. This gives clear visual feedback to the user, immediately showing them what they've filtered by.
• Padding: Increase the padding to add more space between the items, making them easier to click and giving your report a cleaner, less cluttered feel.
• Border: Add subtle borders to each value to help separate them.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Advanced Slicer Formatting Techniques

Once you’ve mastered the basics, you can use a few more advanced techniques to boost the look and functionality of your Power BI report.

Turning Your Slicer into a Button Bar

One of the most popular slicer designs is the horizontal button bar. It's perfect for a small number of filter choices like "Year" or "Department" and gives your report a modern, web-app feel.

1. Select your slicer.
2. Go to the Format your visual icon.
3. Under the Visual tab, expand Slicer settings > Style and ensure List is selected.
4. Switch to the General tab, expand Properties, and find the Orientation setting.
5. Change it from the default Vertical to Horizontal.

The slicer items will now be arranged as buttons. You can resize the visual to create a single row of buttons. All the formatting options under the "Values" section still apply, so you can style them to perfection.

Customizing a Numeric or Date Range Slider

When using a number or date field, your slicer will often default to the "Between" style, creating a slider. You can customize this slider to make it fit your report's design.

• Slider: In the Visual tab, you can change the color of the slider's track.
• Numeric inputs / Date inputs: This section lets you format the text boxes where the start and end of the range are displayed. You have full control over the font, colors, and background for these inputs.

Configuring General Slicer Properties

The "General" tab contains format settings applicable to all visual containers in Power BI. While not exclusive to slicers, these settings are crucial for integrating your slicer into the overall design.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

1. Title

Not to be confused with the "Slicer header," the visual "Title" is a general title for the entire visual object. You can enable it if you've turned off the "Slicer header" but still need a label. Use this to give your slicer a more descriptive name, like "Filter Report by Region."

2. Effects

This is where you make your slicer "pop" or blend seamlessly with its surroundings.

• Background: Change the background color of the slicer's container. You can also adjust the transparency to have your report's background show through.
• Visual Border: Adds a colored outline around the entire slicer. Small details like rounded corners can add a soft, modern touch.
• Shadow: Adds a drop shadow behind the slicer, giving it a sense of depth and making it lift off the page. Used sparingly, this can add a highly professional finish to your dashboard.

Best Practices for Slicer Design

• Keep It Tidy: Don't overwhelm users. For fields with more than 10-15 options, consider using a Dropdown slicer to save space.
• Place Them Intuitively: Users expect to find filters at the top or on the left side of a report. Group related slicers together.
• Sync Slicers Wisely: Use the "Sync slicers" pane (under the View tab) to control which visuals on which pages a slicer affects. This prevents unexpected filtering behavior.
• Use Search: For slicers with hundreds of items, turn on the search option (in the slicer's "..." menu) to help users find what they need quickly.

Final Thoughts

Properly formatting your Power BI slicers is more than just an aesthetic choice, it's about creating an intuitive, efficient, and professional-looking report for your audience. By mastering the settings in the format pane, you can turn a basic filter into a powerful report navigation tool that guides analysis and adds a polished final touch to your work.

Manually building reports in tools like Power BI is a common part of data analysis, but the initial bottleneck is often getting all your different data sources in one place to begin with. Here at Graphed, we remove the complex setup by connecting to your marketing and sales sources - like Google Analytics, Shopify, and Facebook Ads - in just a few clicks. You can then build real-time dashboards and reports instantly by describing what you want in plain English, allowing you to focus on the insights instead of the setup process.